This topic has not yet been rated - Rate this topic

Server::EnumObjectPermissions Method (String)

SQL Server 2012

SQL Server 2005

Enumerates a list of object permissions for a specified grantee on the application instance of SQL Server.

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

Syntax

C++

JScript

public:
array<ObjectPermissionInfo^>^ EnumObjectPermissions(
	String^ granteeName
)

Parameters

granteeName: Type: System::String
A String value that specifies the grantee.

Return Value

Type: array<Microsoft.SqlServer.Management.Smo::ObjectPermissionInfo>
An array of ObjectPermissionInfo objects that contains object permission information for the specified grantee on the instance of SQL Server.

Examples

Server srv = new Server("(local)");
ObjectPermissionInfo[] oPI = srv.EnumObjectPermissions(grantee);
foreach (ObjectPermissionInfo op in oPI)
{
   Console.WriteLine(op.ToString());
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$oPI = $srv.EnumObjectPermissions(grantee)
foreach ($op in $oPI)
{
   Write-Host $op
}

Reference

Server Class

EnumObjectPermissions Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Calling Methods

Managing Servers

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD