Server.EnumObjectPermissions 方法
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.
示例
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
}
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间