Tip: Manage Access and Roles with Transact-SQL (T-SQL) Commands

CREATE USER user_name
	[ { { FOR | FROM }
		{ LOGIN login_name
		| CERTIFICATE certificate_name
		| ASYMMETRIC KEY asym_key_name
		}
	]
	[ WITH DEFAULT_SCHEMA = schema_name ]

ALTER USER user_name
	WITH < set_item > [ ,...n ]
	
< set_item > ::=
	NAME = new_user_name
	| DEFAULT_SCHEMA = schema_name

DROP USER user_name

sp_helpsrvrolemember [[@rolename =] 'role']

CREATE ROLE role_name [ AUTHORIZATION owner_name ]
ALTER ROLE role_name WITH NAME = new_name
DROP ROLE role_name
sp_helprole [[@rolename =] 'role']

sp_addrolemember [@rolename =] 'role',
	[@membername =] 'security_account'
sp_droprolemember [@rolename =] 'role',
	[@membername =] 'security_account'
sp_helprolemember [[@rolename =] 'role']

CREATE APPLICATION ROLE application_role_name
	WITH PASSWORD = 'password' [ , DEFAULT_SCHEMA = schema_name ]

ALTER APPLICATION ROLE application_role_name
	WITH <set_item> [ ,...n ]

<set_item> ::=
	NAME = new_application_role_name
	| PASSWORD = 'password'
	| DEFAULT_SCHEMA = schema_name

DROP APPLICATION ROLE rolename