Share via

  • 發行項

EnumObjectPermissions 方法

列舉 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> [] () [] []
ObjectPermissionInfo 物件的陣列，包含 SQL Server 執行個體的物件權限資訊。

範例

C#

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
}