Table.EnumObjectPermissions 方法

發行項
04/26/2013

Enumerates a list of object permissions for the table.

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

語法

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

returnValue = instance.EnumObjectPermissions()

public ObjectPermissionInfo[] EnumObjectPermissions()

public:
virtual array<ObjectPermissionInfo^>^ EnumObjectPermissions() sealed

abstract EnumObjectPermissions : unit -> ObjectPermissionInfo[] 
override EnumObjectPermissions : unit -> ObjectPermissionInfo[]

public final function EnumObjectPermissions() : ObjectPermissionInfo[]

傳回值

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

實作

IObjectPermission.EnumObjectPermissions()

範例

The following code example demonstrates how to enumerate a list of object permissions for the table.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables)
{
   tb.EnumObjectPermissions();
}

Powershell

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

foreach ($tb in $db.Tables)
{
   $tb.EnumObjectPermissions()
}