UserName 屬性
Gets or sets the database user name.
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public ReadOnly Property UserName As String
Get
'用途
Dim instance As Database
Dim value As String
value = instance.UserName
[SfcPropertyAttribute(SfcPropertyFlags.Expensive)]
public string UserName { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Expensive)]
public:
property String^ UserName {
String^ get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
member UserName : string
function get UserName () : String
屬性值
型別：System. . :: . .String
A String value that specifies the user name.
備註
If you are logged in as sysadmin, the database user is mapped to database owner (DBO).
範例
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'Display information about the database.
Console.WriteLine("Is Database snapshot : " + _
db.IsDatabaseSnapshot.ToString)
Console.WriteLine("Is Database snapshot base : " + _
db.IsDatabaseSnapshotBase.ToString)
Console.WriteLine("User is Aministrator : " + _
db.IsDbAccessAdmin.ToString)
Console.WriteLine("User is backup operator : " + _
db.IsDbBackupOperator.ToString)
Console.WriteLine("User is data reader : " + _
db.IsDbDatareader.ToString)
Console.WriteLine("User is data writer : " + _
db.IsDbDatawriter.ToString)
Console.WriteLine("User is DDL administrator : " + _
db.IsDbDdlAdmin.ToString)
Console.WriteLine("User denied data reader : " + _
db.IsDbDenyDatareader.ToString)
Console.WriteLine("User denied data writer : " + _
db.IsDbDenyDatawriter.ToString)
Console.WriteLine("User is database owner : " + _
db.IsDbOwner.ToString)
Console.WriteLine("User security administrator : " + _
db.IsDbSecurityAdmin.ToString)
Console.WriteLine("Full text is enabled : " + _
db.IsFullTextEnabled.ToString)
Console.WriteLine("Database is a mail host : " + _
db.IsMailHost.ToString)
Console.WriteLine("Mirroring is enabled : " + _
db.IsMirroringEnabled.ToString)
Console.WriteLine("Database is a system object : " + _
db.IsSystemObject.ToString)
Console.WriteLine("Database is updateable : " + _
db.IsUpdateable.ToString)