Database.IsDbOwner Database.IsDbOwner Database.IsDbOwner Property

정의

현재 사용자의 멤버 인지를 지정 하는 값을 가져옵니다는 * * DbOwner * * 데이터베이스 역할입니다. Gets a value that specifies whether the current user is a member of the DbOwner database role.

public:
 property bool IsDbOwner { bool get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDbOwner { get; }
Public ReadOnly Property IsDbOwner As Boolean
속성 값

A Boolean 현재 사용자의 멤버 인지를 지정 하는 값은 * * DbOwner * * 데이터베이스 역할입니다. A Boolean value that specifies whether the current user is a member of the DbOwner database role. 경우 True, 현재 사용자가 멤버인은 * * DbOwner * * 데이터베이스 역할입니다. If True, the current user is a member of the DbOwner database role. 그렇지 않으면 False (기본값). Otherwise, False (default).

예제

VBVB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'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)  

PowerShellPowerShell

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

Write-Host "Is database snapshot :" $db.IsDatabaseShapshot  
Write-Host "Is database snapshot base :" $db.IsDatabaseShapshotBase  
Write-Host "User is Administrator :" $db.IsDbAccessAdmin  
Write-Host "User is backup operator :" $db.IsDbBackupOperator  
Write-Host "User is data rader :" $db.IsDbDataReader  
Write-Host "User is data writer :" $db.IsDbDataWriter  
Write-Host "User is DDL administrator :" $db.IsDbDdlAdmin  
Write-Host "User denied data reader :" $db.IsDbDenyDatareader  
Write-Host "User denied data writer :" $db.IsDbDenyDatawriter  
Write-Host "User dis database owner :" $db.IsDbOwner  
Write-Host "User security administrator :" $db.IsDbSecurityAdmin  
Write-Host "Full text is enabled :" $db.FullTextEnabled  
Write-Host "Database is a mail host :" $db.IsMailHost  
Write-Host "Mirroring is enabled :" $db.IsMirroringEnabled  
Write-Host "Database is a system object :" $db.IsSystemObject  
Write-Host "Database is updateable :" $db.IsUpdateable  

적용 대상