Propriété Users
Représente une collection d'objets User. Chaque objet User représente un utilisateur défini sur la base de données.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(User), SfcObjectFlags.Design)> _
Public ReadOnly Property Users As UserCollection
Get
'Utilisation
Dim instance As Database
Dim value As UserCollection
value = instance.Users
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(User), SfcObjectFlags.Design)]
public UserCollection Users { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(User), SfcObjectFlags::Design)]
public:
property UserCollection^ Users {
UserCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(User), SfcObjectFlags.Design)>]
member Users : UserCollection
function get Users () : UserCollection
Valeur de propriété
Type : Microsoft.SqlServer.Management.Smo. . :: . .UserCollection
Objet UserCollection qui représente tous les utilisateurs définis sur la base de données.
Notes
Specific users can be referenced by using this collection by specifying the name of the user. To add a new user to the collection, call the user constructor.
Exemples
VB
'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 users in the database.
Dim us As User
For Each us In db.Users
Console.WriteLine(us.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 ($us in $db.Users)
{
Write-Host $us.Name
}