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) Deny(ObjectPermissionSet, String) Deny(ObjectPermissionSet, String)

The Deny method negates granted user permission for one or more users or roles.

(Inherited from IObjectPermission)
Deny(ObjectPermissionSet, String, Boolean) Deny(ObjectPermissionSet, String, Boolean) Deny(ObjectPermissionSet, String, Boolean)

The Deny method negates granted user permission for one or more users or roles. 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.

(Inherited from IObjectPermission)
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[]) Deny(ObjectPermissionSet, String[]) Deny(ObjectPermissionSet, String[])

The Deny method negates granted user permission for one or more users or roles.

(Inherited from IObjectPermission)
Deny(ObjectPermissionSet, String[], Boolean) Deny(ObjectPermissionSet, String[], Boolean) Deny(ObjectPermissionSet, String[], Boolean)

The Deny method negates granted user permission for one or more users or roles. 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.

(Inherited from IObjectPermission)
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 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.

EnumObjectPermissions() EnumObjectPermissions() EnumObjectPermissions()

Returns an array of Permission objects identifying all explicitly granted object access permissions.

(Inherited from IObjectPermission)
EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet)

Returns an array of Permission objects identifying explicitly granted object access permissions. The permissions parameter specifies the object access permissions enumerated for the referenced object.

(Inherited from IObjectPermission)
EnumObjectPermissions(String) EnumObjectPermissions(String) EnumObjectPermissions(String)

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

(Inherited from IObjectPermission)
EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet)

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

(Inherited from IObjectPermission)
Grant(ObjectPermissionSet, String) Grant(ObjectPermissionSet, String) Grant(ObjectPermissionSet, String)

The Grant method assigns permissions to one or more users or roles.

(Inherited from IObjectPermission)
Grant(ObjectPermissionSet, String, Boolean) Grant(ObjectPermissionSet, String, Boolean) Grant(ObjectPermissionSet, String, Boolean)

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

(Inherited from IObjectPermission)
Grant(ObjectPermissionSet, String, Boolean, String) Grant(ObjectPermissionSet, String, Boolean, String) Grant(ObjectPermissionSet, String, Boolean, String)

The Grant method assigns permissions to one or more users or roles. 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 permission to execute the grant.

(Inherited from IObjectPermission)
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[], 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, 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[]) Grant(ObjectPermissionSet, String[]) Grant(ObjectPermissionSet, String[])

The Grant method assigns permissions to one or more users or roles.

(Inherited from IObjectPermission)
Grant(ObjectPermissionSet, String[], Boolean) Grant(ObjectPermissionSet, String[], Boolean) Grant(ObjectPermissionSet, String[], Boolean)

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

(Inherited from IObjectPermission)
Grant(ObjectPermissionSet, String[], Boolean, String) Grant(ObjectPermissionSet, String[], Boolean, String) Grant(ObjectPermissionSet, String[], Boolean, String)

The Grant method assigns permissions to one or more users or roles. 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 permission to execute the grant.

(Inherited from IObjectPermission)
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[], 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, 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.

Revoke(ObjectPermissionSet, String) Revoke(ObjectPermissionSet, String) Revoke(ObjectPermissionSet, String)

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

(Inherited from IObjectPermission)
Revoke(ObjectPermissionSet, String, Boolean, Boolean, String) Revoke(ObjectPermissionSet, String, Boolean, Boolean, String) Revoke(ObjectPermissionSet, 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.

(Inherited from IObjectPermission)
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[], 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, 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[]) Revoke(ObjectPermissionSet, String[]) Revoke(ObjectPermissionSet, String[])

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

(Inherited from IObjectPermission)
Revoke(ObjectPermissionSet, String[], Boolean, Boolean) Revoke(ObjectPermissionSet, String[], Boolean, Boolean) Revoke(ObjectPermissionSet, 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.

(Inherited from IObjectPermission)
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 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 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