Create a user and a table, and make the user own the table : USER « User Role « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. User Role
3. USER

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>