Database.Deny Database.Deny Database.Deny Method

Definition

Denies the specified set of permissions for the specified grantees on the database.

Overloads

Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String)

Denies the specified set of permissions for the specified grantee on the database.

Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[])

Denies the specified set of permissions for the specified grantees on the database.

Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean)

Denies the specified set of permissions for the specified grantee and other users who the grantee granted the specified set of permissions on the database.

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

Denies the specified set of permissions for the specified grantees and other users who the grantee granted the specified set of permissions on the database.

Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String) Deny(DatabasePermissionSet, String)

Denies the specified set of permissions for the specified grantee on the database.

public:
 void Deny(Microsoft::SqlServer::Management::Smo::DatabasePermissionSet ^ permission, System::String ^ granteeName);
public void Deny (Microsoft.SqlServer.Management.Smo.DatabasePermissionSet permission, string granteeName);
Public Sub Deny (permission As DatabasePermissionSet, granteeName As String)
Parameters
permission
DatabasePermissionSet DatabasePermissionSet DatabasePermissionSet

A DatabasePermissionSet object value that specifies the set of permissions.

granteeName
String String String

A String value that specifies the grantee to be denied the specified set of permissions on the database.

Examples

The example shows how to use the Deny method with server permissions. The method is used in the same way with database permissions.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint  

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)  
$spis = $srv.EnumServerPermissions("vGrantee", $sps)  
Write-Host "=================Before revoke==========================="  
Foreach ($spi In $spis)  
{  
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."  
}  
Write-Host " "  
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  

Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[]) Deny(DatabasePermissionSet, String[])

Denies the specified set of permissions for the specified grantees on the database.

public:
 void Deny(Microsoft::SqlServer::Management::Smo::DatabasePermissionSet ^ permission, cli::array <System::String ^> ^ granteeNames);
public void Deny (Microsoft.SqlServer.Management.Smo.DatabasePermissionSet permission, string[] granteeNames);
Public Sub Deny (permission As DatabasePermissionSet, granteeNames As String())
Parameters
permission
DatabasePermissionSet DatabasePermissionSet DatabasePermissionSet

A DatabasePermissionSet object value that specifies the set of permissions.

granteeNames
String[]

A String array that specifies a list of grantees to be denied the specified set of permissions on the database.

Examples

The example shows how to use the Deny method with server permissions. The method is used in the same way with database permissions.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint  

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)  
$spis = $srv.EnumServerPermissions("vGrantee", $sps)  
Write-Host "=================Before revoke==========================="  
Foreach ($spi In $spis)  
{  
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."  
}  
Write-Host " "  
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  

Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean) Deny(DatabasePermissionSet, String, Boolean)

Denies the specified set of permissions for the specified grantee and other users who the grantee granted the specified set of permissions on the database.

public:
 void Deny(Microsoft::SqlServer::Management::Smo::DatabasePermissionSet ^ permission, System::String ^ granteeName, bool cascade);
public void Deny (Microsoft.SqlServer.Management.Smo.DatabasePermissionSet permission, string granteeName, bool cascade);
Public Sub Deny (permission As DatabasePermissionSet, granteeName As String, cascade As Boolean)
Parameters
permission
DatabasePermissionSet DatabasePermissionSet DatabasePermissionSet

A DatabasePermissionSet object value that specifies the set of permissions.

granteeName
String String String

A String value that specifies the grantee to be denied the specified set of permissions on the database.

cascade
Boolean Boolean Boolean

A Boolean property that specifies whether users, to whom the grantee granted the specified set of permission, are also denied access to the specified set of permissions on the database.

If True, the grantee and users to which the grantee granted the specified set of permissions are all denied the specified set of permissions. If False, only the grantee is denied the specified set of permissions.

Examples

The example shows how to use the Deny method with server permissions. The method is used in the same way with database permissions.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint  

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)  
$spis = $srv.EnumServerPermissions("vGrantee", $sps)  
Write-Host "=================Before revoke==========================="  
Foreach ($spi In $spis)  
{  
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."  
}  
Write-Host " "  
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  

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

Denies the specified set of permissions for the specified grantees and other users who the grantee granted the specified set of permissions on the database.

public:
 void Deny(Microsoft::SqlServer::Management::Smo::DatabasePermissionSet ^ permission, cli::array <System::String ^> ^ granteeNames, bool cascade);
public void Deny (Microsoft.SqlServer.Management.Smo.DatabasePermissionSet permission, string[] granteeNames, bool cascade);
Public Sub Deny (permission As DatabasePermissionSet, granteeNames As String(), cascade As Boolean)
Parameters
permission
DatabasePermissionSet DatabasePermissionSet DatabasePermissionSet

A DatabasePermissionSet object value that specifies the set of permissions.

granteeNames
String[]

A String array that specifies a list of grantees to be denied the specified set of permissions.

cascade
Boolean Boolean Boolean

A Boolean property that specifies whether users, to whom the grantee granted the specified set of permission, are also denied access to the specified set of permissions on the database.

If True, the grantee and users to which the grantee granted the specified set of permissions are all denied the specified set of permissions. If False, only the grantee is denied the specified set of permissions.

Examples

The example shows how to use the Deny method with server permissions. The method is used in the same way with database permissions.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint  

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)  
$spis = $srv.EnumServerPermissions("vGrantee", $sps)  
Write-Host "=================Before revoke==========================="  
Foreach ($spi In $spis)  
{  
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."  
}  
Write-Host " "  
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)  

Applies to