SQL Server/T-SQL Tutorial/System Functions/sp GrantDbAccess
A statement that grants access to a database for a SQL Server login ID
<source lang="sql">
EXEC sp_GrantDbAccess JohnDoe</source>
System stored procedures for granting and revoking access to the current database
<source lang="sql">
The syntax for sp_GrantDbAccess sp_GrantDbAccess [@loginame = ] "login_ID"
[,[@name_in_db = ] "database_alias"]
The syntax for sp_RevokeDbAccess sp_RevokeDbAccess "name_in_db" Statements that use these procedures</source>