Microsoft® SQL Server 2012 Unleashed

Using T-SQL to Manage Users

CREATE USER, ALTER USER, and DROP USER are the T-SQL commands you use most often to manage database users. These commands are replacements for the system stored procedures used in prior versions. The system stored procedures, such as sp_adduser, sp_dropuser, sp_grantdbaccess, and sp_revokedbaccess, have been deprecated and will be removed in a future version. They are still available for use now, but you should avoid them when possible.

The following example demonstrates the use of the CREATE USER statement to create a new database user named Laura, with a default schema Sales:

Click here to view code image

CREATE USER Laura FOR LOGIN Laura    WITH DEFAULT_SCHEMA = Sales

You can use the ALTER USER statement to change ...