ServerRole Object (SQL-DMO)

The ServerRole object exposes the attributes of a single Microsoft® SQL Server™ security role not constrained to operation within a single database.

Remarks

SQL Server security roles establish rights to SQL Server resources for more than a single user and can be established within the constraint of a single database. Security roles can also grant permissions to an authenticated user for a SQL Server installation. For example, the server role securityadmin has permissions that allow members to add, change, and remove SQL Server logins.

With the ServerRole object, you can:

• Assign membership in a server role to a SQL Server login.
• Remove a member login from a SQL Server security role.

SQL Server establishes server roles. New server roles cannot be defined by the user. For more information about a list of valid ServerRole Name strings, see sp_addsrvrolemember.

Methods

Properties