IColumnPermission IColumnPermission IColumnPermission Interface

Definition

Interface for column-level object permissions.

public interface IColumnPermission : Microsoft.SqlServer.Management.Smo.IObjectPermission
type IColumnPermission = interface
    interface IObjectPermission
Public Interface IColumnPermission
Implements IObjectPermission
Derived
Implements

Methods

Deny(ObjectPermissionSet, String, String[]) Deny(ObjectPermissionSet, String, String[]) Deny(ObjectPermissionSet, String, String[])

The Deny method negates granted user permission for one or more users or roles, for the specified columnNames.

Deny(ObjectPermissionSet, String[], String[]) Deny(ObjectPermissionSet, String[], String[]) Deny(ObjectPermissionSet, String[], String[])

The Deny method negates granted user permission for one or more users or roles, for the specified columnNames.

Deny(ObjectPermissionSet, String, String[], Boolean) Deny(ObjectPermissionSet, String, String[], Boolean) Deny(ObjectPermissionSet, String, String[], Boolean)

The Deny method negates granted user permission for one or more users or roles, for the specified columnNames. Cascade specifies that permissions are denied from granteeName as well as any other security accounts granted permissions by granteeName. Use Cascade when denying a grantable permission.

Deny(ObjectPermissionSet, String[], String[], Boolean) Deny(ObjectPermissionSet, String[], String[], Boolean) Deny(ObjectPermissionSet, String[], String[], Boolean)

The Deny method negates granted user permission for one or more users or roles, for the specified columnNames. Cascade specifies that permissions are denied from granteeNames as well as any other security accounts granted permissions by granteeNames. Use Cascade when denying a grantable permission.

EnumColumnPermissions(String) EnumColumnPermissions(String) EnumColumnPermissions(String)

Returns an array of Permission objects identifying explicitly granted column access permissions for the grantee specified with the granteeName parameter.

EnumColumnPermissions(String, ObjectPermissionSet) EnumColumnPermissions(String, ObjectPermissionSet) EnumColumnPermissions(String, ObjectPermissionSet)

Returns an array of Permission objects identifying explicitly granted column access permissions for the grantee specified with the granteeName parameter, restricted to the column access permissions specified with the privilegeTypes parameter.

Grant(ObjectPermissionSet, String[], String[], Boolean, String) Grant(ObjectPermissionSet, String[], String[], Boolean, String) Grant(ObjectPermissionSet, String[], String[], Boolean, String)

The Grant method assigns permissions to one or more users or roles for the specified columns. When grantGrant is true, the grantee(s) specified are granted the ability to execute the GRANT statement referencing the object. Use the AsRole argument to specify the role under which role to execute the grant.

Grant(ObjectPermissionSet, String, String[], Boolean, String) Grant(ObjectPermissionSet, String, String[], Boolean, String) Grant(ObjectPermissionSet, String, String[], Boolean, String)

The Grant method assigns permissions to one or more users or roles for the specified columns. When grantGrant is true, the grantee(s) specified are granted the ability to execute the GRANT statement referencing the object. Use the AsRole argument to specify the role under which role to execute the grant.

Grant(ObjectPermissionSet, String[], String[], Boolean) Grant(ObjectPermissionSet, String[], String[], Boolean) Grant(ObjectPermissionSet, String[], String[], Boolean)

The Grant method assigns permissions to one or more users or roles for the specified columns. When grantGrant is true, the grantee(s) specified are granted the ability to execute the GRANT statement referencing the object.

Grant(ObjectPermissionSet, String, String[], Boolean) Grant(ObjectPermissionSet, String, String[], Boolean) Grant(ObjectPermissionSet, String, String[], Boolean)

The Grant method assigns permissions to one or more users or roles for the specified columns. When grantGrant is true, the grantee(s) specified are granted the ability to execute the GRANT statement referencing the object.

Grant(ObjectPermissionSet, String[], String[]) Grant(ObjectPermissionSet, String[], String[]) Grant(ObjectPermissionSet, String[], String[])

The Grant method assigns permissions to one or more users or roles for the specified columns.

Grant(ObjectPermissionSet, String, String[]) Grant(ObjectPermissionSet, String, String[]) Grant(ObjectPermissionSet, String, String[])

The Grant method assigns permissions to one or more users or roles for the specified columns.

Revoke(ObjectPermissionSet, String, String[]) Revoke(ObjectPermissionSet, String, String[]) Revoke(ObjectPermissionSet, String, String[])

Removes previously granted or denied column permission for the specified granteeName.

Revoke(ObjectPermissionSet, String[], String[]) Revoke(ObjectPermissionSet, String[], String[]) Revoke(ObjectPermissionSet, String[], String[])

Removes previously granted or denied column permission for the specified granteeNames.

Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean) Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean) Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean)

Removes a previously granted or denied permission for the specified granteeName. When revokeGrant is true, the ability to extend permissions is revoked. Cascade specifies that permissions are removed from granteeName as well as any other security accounts granted permissions by granteeName. Use Cascade when revoking a grantable permission.

Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean) Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean) Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean)

Removes a previously granted or denied permission for the specified granteeNames. When revokeGrant is true, the ability to extend permissions is revoked. Cascade specifies that permissions are removed from granteeNames as well as any other security accounts granted permissions by granteeNames. Use Cascade when revoking a grantable permission.

Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean, String) Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean, String) Revoke(ObjectPermissionSet, String, String[], Boolean, Boolean, String)

Removes a previously granted or denied permission for the specified granteeName. When revokeGrant is true, the ability to extend permissions is revoked. Cascade specifies that permissions are removed from granteeName as well as any other security accounts granted permissions by granteeName. Use Cascade when revoking a grantable permission. Use the AsRole argument to specify the role under which permission to execute the revoke.

Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean, String) Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean, String) Revoke(ObjectPermissionSet, String[], String[], Boolean, Boolean, String)

Removes a previously granted or denied permission for the specified granteeNames. When revokeGrant is true, the ability to extend permissions is revoked. Cascade specifies that permissions are removed from granteeNames as well as any other security accounts granted permissions by granteeNames. Use Cascade when revoking a grantable permission. Use the AsRole argument to specify the role under which permission to execute the revoke.

Applies to