共用方式為


IColumnPermission.Revoke Method

Definition

Overloads

Revoke(ObjectPermissionSet, String, String[])

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

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

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

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)

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)

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)

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.

Revoke(ObjectPermissionSet, String, String[])

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

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string granteeName, string[] columnNames);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string * string[] -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeName As String, columnNames As String())

Parameters

permissions
ObjectPermissionSet
granteeName
String
columnNames
String[]

Applies to

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

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

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string[] * string[] -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeNames As String(), columnNames As String())

Parameters

permissions
ObjectPermissionSet
granteeNames
String[]
columnNames
String[]

Applies to

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.

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool revokeGrant, bool cascade);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string * string[] * bool * bool -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeName As String, columnNames As String(), revokeGrant As Boolean, cascade As Boolean)

Parameters

permissions
ObjectPermissionSet
granteeName
String
columnNames
String[]
revokeGrant
Boolean
cascade
Boolean

Applies to

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.

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string[] * string[] * bool * bool -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeNames As String(), columnNames As String(), revokeGrant As Boolean, cascade As Boolean)

Parameters

permissions
ObjectPermissionSet
granteeNames
String[]
columnNames
String[]
revokeGrant
Boolean
cascade
Boolean

Applies to

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.

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool revokeGrant, bool cascade, string asRole);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string * string[] * bool * bool * string -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeName As String, columnNames As String(), revokeGrant As Boolean, cascade As Boolean, asRole As String)

Parameters

permissions
ObjectPermissionSet
granteeName
String
columnNames
String[]
revokeGrant
Boolean
cascade
Boolean
asRole
String

Applies to

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.

public void Revoke (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade, string asRole);
abstract member Revoke : Microsoft.SqlServer.Management.Smo.ObjectPermissionSet * string[] * string[] * bool * bool * string -> unit
Public Sub Revoke (permissions As ObjectPermissionSet, granteeNames As String(), columnNames As String(), revokeGrant As Boolean, cascade As Boolean, asRole As String)

Parameters

permissions
ObjectPermissionSet
granteeNames
String[]
columnNames
String[]
revokeGrant
Boolean
cascade
Boolean
asRole
String

Applies to