Promotic
WikipediaLinkedInYoutubeTwitterFacebook

sp_grantdbaccess - statement of language DB_MSSQL

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 Enables 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'
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice