Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

System stored procedures for granting and revoking access to the current database

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