Export (0) Print
Expand All

Database.EnumObjectPermissions Method

 

Applies To: SQL Server 2016 Preview

Enumerates a list of permissions for objects in the database.

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

NameDescription
System_CAPS_pubmethodEnumObjectPermissions()

Enumerates a list of permissions for objects in the database.

System_CAPS_pubmethodEnumObjectPermissions(ObjectPermissionSet)

Enumerates a list of permissions for objects in the database limited to the specified permission set.

System_CAPS_pubmethodEnumObjectPermissions(String)

Enumerates a list of permissions for objects in the database that belong to the specified user.

System_CAPS_pubmethodEnumObjectPermissions(String, ObjectPermissionSet)

Enumerates a list of permissions for objects in the database that belong to the specified user and limited to the specified permission set.

Return to top

Database.EnumObjectPermissions Method ()

Enumerates a list of permissions for objects in the database.

public ObjectPermissionInfo[] EnumObjectPermissions()

Return Value

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

An array of ObjectPermissionInfo objects that contains a list of object permissions for the database.

Legacy Code Example

The example shows the EnumServerPermissions method, which is used like the EnumObjectPermissions method.

VB

Code snippet is not found. Confirm that the code snippet name 'SMO How to' is correct.

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)
$spis = $srv.EnumServerPermissions("vGrantee", $sps)
Write-Host "=================Before revoke==========================="
Foreach ($spi In $spis)
{
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."
}
Write-Host " "
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
Return to top

Database.EnumObjectPermissions Method (ObjectPermissionSet)

Enumerates a list of permissions for objects in the database limited to the specified permission set.

public ObjectPermissionInfo[] EnumObjectPermissions(
	ObjectPermissionSet permissions
)

Parameters

permissions
Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet

A ObjectPermissionSet object that limits the enumerated list to those listed.

Return Value

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

An array of ObjectPermissionInfo objects that contains a list of object permissions for the database.

Legacy Code Example

The example shows the EnumServerPermissions method, which is used like the EnumObjectPermissions method.

VB

Code snippet is not found. Confirm that the code snippet name 'SMO How to' is correct.

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)
$spis = $srv.EnumServerPermissions("vGrantee", $sps)
Write-Host "=================Before revoke==========================="
Foreach ($spi In $spis)
{
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."
}
Write-Host " "
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
Return to top

Database.EnumObjectPermissions Method (String)

Enumerates a list of permissions for objects in the database that belong to the specified user.

public ObjectPermissionInfo[] EnumObjectPermissions(
	string granteeName
)

Parameters

granteeName
Type: System.String

A String value that specifies the user who is the owner of the objects.

Return Value

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

An array of ObjectPermissionInfo objects that contains a list of object permissions for the specified owner.

Legacy Code Example

The example shows the EnumServerPermissions method, which is used like the EnumObjectPermissions method.

VB

Code snippet is not found. Confirm that the code snippet name 'SMO How to' is correct.

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)
$spis = $srv.EnumServerPermissions("vGrantee", $sps)
Write-Host "=================Before revoke==========================="
Foreach ($spi In $spis)
{
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."
}
Write-Host " "
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
Return to top

Database.EnumObjectPermissions Method (String, ObjectPermissionSet)

Enumerates a list of permissions for objects in the database that belong to the specified user and limited to the specified permission set.

public ObjectPermissionInfo[] EnumObjectPermissions(
	string granteeName,
	ObjectPermissionSet permissions
)

Parameters

granteeName
Type: System.String

A String value that specifies the user who is the owner of the objects.

permissions
Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet

A DatabasePermissionSet object that limits the enumerated list to those listed.

Return Value

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

An array of ObjectPermissionInfo objects that contains a list of permissions for the specified owner and permission set.

Legacy Code Example

The example shows the EnumServerPermissions method, which is used like the EnumObjectPermissions method.

VB

Code snippet is not found. Confirm that the code snippet name 'SMO How to' is correct.

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$arg = [Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint

$sps = new-object Microsoft.SqlServer.Management.Smo.ServerPermissionSet([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
$sps.Add([Microsoft.SqlServer.Management.Smo.ServerPermission]::AlterAnyEndpoint)
$spis = $srv.EnumServerPermissions("vGrantee", $sps)
Write-Host "=================Before revoke==========================="
Foreach ($spi In $spis)
{
   Write-Host $spi.Grantee "has" $spi.PermissionType " permission."
}
Write-Host " "
$sps.Remove([Microsoft.SqlServer.Management.Smo.ServerPermission]::CreateEndpoint)
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft