This topic has not yet been rated - Rate this topic

ObjectPermissionSet.Alter Property

SQL Server 2012

Gets or sets the Boolean property value that specifies whether to include the ALTER permission in the permission set. The permission lets the grantee change properties, except ownership, of the object.

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

Syntax

C++

JScript

public bool Alter { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether to include the ALTER permission in the permission set.If True, the permission is included in the permission set.If False (default), the permission is excluded from the permission set.

Remarks

The ALTER permission on a schema includes the ability to create, alter, and drop objects from the schema.

Examples

Granting, Revoking, and Denying Permissions

Reference

ObjectPermissionSet Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD