次の方法で共有

  • [アーティクル]

DboLogin プロパティ

現在のユーザーがデータベース所有者 (DBO) としてログオンしているかどうかを示す Boolean 値を取得します。

名前空間:  Microsoft.SqlServer.Management.Smo
アセンブリ:  Microsoft.SqlServer.Smo (Microsoft.SqlServer.Smo.dll)

構文

'宣言
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property DboLogin As Boolean
    Get
'使用
Dim instance As Database
Dim value As Boolean

value = instance.DboLogin

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool DboLogin { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool DboLogin {
    bool get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member DboLogin : bool

function get DboLogin () : boolean

プロパティ値

型: System. . :: . .Boolean
現在のユーザーが DBO としてログオンしているかどうかを示す Boolean 値。
True の場合、現在のユーザーは DBO としてログオンしています。それ以外の場合は、False (既定値) です。

説明

DBO には sysadmin ロールもマップされます。

使用例

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 information about the database.
Console.WriteLine("Name = " + db.Name.ToString)
Console.WriteLine("ID = " + db.ID.ToString)
Console.WriteLine("Owner = " + db.Owner.ToString)
Console.WriteLine("Parent = " + db.Parent.ToString)
Console.WriteLine("State = " + db.State.ToString)
Console.WriteLine("Status = " + db.Status.ToString)
Console.WriteLine("User Name = " + db.UserName.ToString)
Console.WriteLine("DBO Login = " + db.DboLogin.ToString)
Console.WriteLine("Version = " + db.Version.ToString)
Console.WriteLine("Service Broker = " + _
db.ServiceBroker.ToString)
Console.WriteLine("Replication Options = " + _
db.ReplicationOptions.ToString)
Console.WriteLine("Default File Group = " + _
db.DefaultFileGroup.ToString)
Console.WriteLine("Default FTS catalog = " + _
db.DefaultFullTextCatalog.ToString)
Console.WriteLine("Default Schema = " + _
db.DefaultSchema.ToString)

PowerShell

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

Write-Host "Name =" $db.Name
Write-Host "ID =" $db.ID
Write-Host "Owner =" $db.Ownder
Write-Host "Parent =" $db.Parent
Write-Host "State =" $db.State
Write-Host "Status =" $db.Status
Write-Host "User Name =" $db.UserName
Write-Host "DBO Login =" $db.DboLogin
Write-Host "Version =" $db.Version
Write-Host "Service Broker =" $db.ServiceBroker
Write-Host "Replication Options =" $db.ReplicationOptions
Write-Host "Default File Group =" $db.DefaultFileGroup
Write-Host "Default FTS catalog =" $db.DefaultFullTextCatalog
Write-Host "Default Schema =" $db.DefaultSchema