DatabaseRole Class
The DatabaseRole object represents a Microsoft SQL Server database security role.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Microsoft.SqlServer.Management.Smo Namespace
Database Roles
CREATE ROLE (Transact-SQL)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public sealed class DatabaseRole : ScriptNameObjectBase, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable
public final class DatabaseRole extends ScriptNameObjectBase implements IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable
Updated text: 12 December 2006
To get DatabaseRole object properties, users can be a member of the public fixed server role.
To set DatabaseRole object properties, users must have ALTER permission on the database role.
To create a database role, users must have CREATE ROLE permission on the parent database.
To drop a database role, users must have ALTER ANY ROLE permission on the parent database.
To add or remove members from the database role, users must be members of the db_owner or db_security admin fixed database role.
To grant, deny, or revoke permission on the database for other users, users must have CONTROL permission on the database role.
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Reference
DatabaseRole MembersMicrosoft.SqlServer.Management.Smo Namespace
Other Resources
Managing Users, Roles, and LoginsDatabase Roles
CREATE ROLE (Transact-SQL)
