Mega Code Archive
Create a user and a table, and make the user own the table
<![CDATA[
4> CREATE USER Tom
5> WITHOUT LOGIN
6> GO
1> CREATE TABLE TomsData
2> (
3> AColumn INT
4> )
5> GO
1>
2> ALTER AUTHORIZATION ON TomsData TO Tom
3> GO
1>
2>
3> --Impersonate the user
4> EXECUTE AS USER='Tom'
5> GO
1>
2> SELECT USER_NAME()
3> GO
--------------------------------------------------------------------------------------------------------------------------------
Tom
(1 rows affected)
1>
2> drop table TomsData;
3> drop user tom;
4> GO
Msg 15151, Level 16, State 1, Server J\SQLEXPRESS, Line 3
Cannot drop the user 'tom', because it does not exist or you do not have permission.
1>
]]>