Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Table.EnumObjectPermissions Method (String)


Enumerates a list of object permissions for a specified grantee on the table.

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

public ObjectPermissionInfo[] EnumObjectPermissions(
	string granteeName


Type: System.String

A String value that specifies the grantee.

Return Value

Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[]

An array of ObjectPermissionInfo objects that contains object permission information for the specified grantee on the table.

The following code example demonstrates how to enumerate a list of object permissions for a specific grantee.


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

foreach (Table tb in db.Tables)


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

foreach ($tb in $db.Tables)
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft