Server.EnumObjectPermissions 方法

發行項
07/13/2013

Enumerates a list of object permissions for the instance of SQL Server.

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function EnumObjectPermissions As ObjectPermissionInfo()
'用途
Dim instance As Server 
Dim returnValue As ObjectPermissionInfo()

returnValue = instance.EnumObjectPermissions()

public ObjectPermissionInfo[] EnumObjectPermissions()

public:
array<ObjectPermissionInfo^>^ EnumObjectPermissions()

member EnumObjectPermissions : unit -> ObjectPermissionInfo[]

public function EnumObjectPermissions() : ObjectPermissionInfo[]

傳回值

型別：array<Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[]
An array of ObjectPermissionInfo objects that contains object permission information for the instance of SQL Server.

範例

Server srv = new Server("(local)");

ObjectPermissionInfo[] oPI = srv.EnumObjectPermissions();
foreach (ObjectPermission op in oPI[])
{
   Console.WriteLine(op.ToString());
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$oPI = $srv.EnumObjectPermissions()
foreach ($op in $oPI)
{
   Write-Host $op
}