Export (0) Print
Expand All

PrivilegeTypes Enumeration

 

Applies To: SQL Server 2016 Preview

The PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[FlagsAttribute]
public enum PrivilegeTypes

Member nameDescription
AllDatabasePrivileges

The grantee has all privileges on the specified database. This privilege type applies to database objects.

AllObjectPrivileges

The grantee has all the privileges that apply to the specified database object.

Alter

The grantee can alter the specified database.

BackupDatabase

The grantee can back up the specified database.

BackupLog

The grantee can back up the transaction log for the specified database.

Control

The grantee has full control over the specified database.

CreateDatabase

The grantee can create the database.

CreateDefault

The grantee can create a default database object on the specified database.

CreateFunction

The grantee can create a user-defined function of the specified database.

CreateProcedure

The grantee can create stored procedure on the specified database.

CreateRule

The grantee can create a rule on the specified database.

CreateTable

The grantee can create a table on the specified database.

CreateType

The grantee can create a user-defined type on the specified database.

CreateView

The grantee can create a view on the specified database.

Delete

The grantee can delete the specified database object.

Drop

The grantee can drop the database.

DumpDatabase

The grantee can dump the data in the specified database.

DumpTable

The grantee can dump the data in the specified table.

DumpTransaction

The grantee can dump the data in the specified transaction log.

Execute

The grantee can execute the specified database object.

Insert

The grantee can insert records into the specified database object.

References

The grantee can reference a column in another table in a primary key/foreign key relationship.

Select

The grantee can select records from the specified database object.

Unknown

The grantee's privileges are unspecified.

Update

The grantee can update records on the specified database object.

ViewDefinition

The grantee can view the definition of the specified database.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft