StoredProcedure.Deny Method (ObjectPermissionSet, String)

Denies the specified set of permissions for the specified grantee on the stored procedure.

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

Syntax

'Declaration
Public Sub Deny ( _
    permission As ObjectPermissionSet, _
    granteeName As String _
)
'Usage
Dim instance As StoredProcedure 
Dim permission As ObjectPermissionSet 
Dim granteeName As String

instance.Deny(permission, granteeName)
public void Deny(
    ObjectPermissionSet permission,
    string granteeName
)
public:
virtual void Deny(
    ObjectPermissionSet^ permission, 
    String^ granteeName
) sealed
abstract Deny : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit  
override Deny : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit
public final function Deny(
    permission : ObjectPermissionSet, 
    granteeName : String
)

Parameters

  • granteeName
    Type: System.String
    A String value that specifies the grantee to be denied the specified set of permissions on the stored procedure.

Implements

IObjectPermission.Deny(ObjectPermissionSet, String)

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

StoredProcedure Class

Deny Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)