Propriedade do RDL Roles
Representa uma coleção de objetos DatabaseRole. Cada objeto DatabaseRole representa uma função definida no banco de dados.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(DatabaseRole), SfcObjectFlags.Design)> _
Public ReadOnly Property Roles As DatabaseRoleCollection
Get
'Uso
Dim instance As Database
Dim value As DatabaseRoleCollection
value = instance.Roles
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(DatabaseRole), SfcObjectFlags.Design)]
public DatabaseRoleCollection Roles { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(DatabaseRole), SfcObjectFlags::Design)]
public:
property DatabaseRoleCollection^ Roles {
DatabaseRoleCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(DatabaseRole), SfcObjectFlags.Design)>]
member Roles : DatabaseRoleCollection
function get Roles () : DatabaseRoleCollection
Valor da propriedade
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .DatabaseRoleCollection
Um objeto DatabaseRoleCollection que representa todas as funções definidas no banco de dados.
Comentários
Specific database roles can be referenced by using this collection by specifying the name of the database role. To add a new database role to the collection, call the database role constructor DatabaseRole.
Exemplos
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Display all the database roles in the database.
Dim ro As DatabaseRole
For Each ro In db.Roles
Console.WriteLine(ro.Name)
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($ro in $db.Roles)
{
Write-Host $ro.Name
}