sp_addsrvrolemember - statement of language DB_MSSQL

Adds 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.

  [ @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).
The fixed role of the SQL Server holds globally in the SQL Server. The database role holds for the certain database.
Adds the account 'pm_admin' into the fixed role of the server 'sysadmin' (this account can be used for administration of the SQL Server).
EXEC sp_addsrvrolemember 'pm_admin', 'sysadmin'
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.