Promotic
WikipediaLinkedInYoutubeTwitterFacebook

sp_addsrvrolemember - statement of language DB_MSSQL

Description:
Add an account as a fixed role member of the SQL Server. Then the account gets rights connected with the appropriate fixed role in the SQL Server.
Syntax:

sp_addsrvrolemember

  [ @loginame = ] 'login'

  [ @rolename = ] 'role'

 
@loginame Account for which an access to the current database will be enabled.
@rolename Role of the server into which the account will be added (sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin).
Note:
The fixed role of the SQL Server holds globally in the SQL Server. The database role holds for the certain database.
Example:
Add the account 'pm_admin' into the fixed role of the server 'sysadmin' (then this account can be used for administration of the SQL Server).
EXEC sp_addsrvrolemember 'pm_admin', 'sysadmin'
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice