Description:
Enable an access of the specified login account to the current database.
Syntax:
sp_grantdbaccess
[
@loginame =] 'login'
[, [
@name_in_db =] 'name_in_db']
| @loginame |
Login account to which the access to the current database will be enabled (SQL Server authentication or Windows NT authentication). |
| @name_in_db |
Allows to change the name under which the login account will be handled in this database (the default value is NULL; name of the login account will be used). |
Example:
Enable an access to the account 'pm_reader' of the database 'pm_data'.
USE pm_data
EXEC sp_grantdbaccess 'pm_reader'