DatabaseRole 類別

The DatabaseRole object represents a SQL Server database security role.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
    Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
      Microsoft.SqlServer.Management.Smo. . :: . .NamedSmoObject
        Microsoft.SqlServer.Management.Smo. . :: . .ScriptNameObjectBase
          Microsoft.SqlServer.Management.Smo..::..DatabaseRole

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcElementTypeAttribute("Role")> _
<StateChangeEventAttribute("CREATE_ROLE", "ROLE")> _
<StateChangeEventAttribute("ALTER_ROLE", "ROLE")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "ROLE")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.Enforce Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class DatabaseRole _
    Inherits ScriptNameObjectBase _
    Implements ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable,  _
    IAlterable, IRenamable, IExtendedProperties, IScriptable
'用途
Dim instance As DatabaseRole

[SfcElementTypeAttribute("Role")]
[StateChangeEventAttribute("CREATE_ROLE", "ROLE")]
[StateChangeEventAttribute("ALTER_ROLE", "ROLE")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "ROLE")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class DatabaseRole : ScriptNameObjectBase, 
    ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, 
    IRenamable, IExtendedProperties, IScriptable

[SfcElementTypeAttribute(L"Role")]
[StateChangeEventAttribute(L"CREATE_ROLE", L"ROLE")]
[StateChangeEventAttribute(L"ALTER_ROLE", L"ROLE")]
[StateChangeEventAttribute(L"ALTER_AUTHORIZATION_DATABASE", L"ROLE")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::Enforce|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class DatabaseRole sealed : public ScriptNameObjectBase, 
    ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, 
    IRenamable, IExtendedProperties, IScriptable

[<SealedAttribute>]
[<SfcElementTypeAttribute("Role")>]
[<StateChangeEventAttribute("CREATE_ROLE", "ROLE")>]
[<StateChangeEventAttribute("ALTER_ROLE", "ROLE")>]
[<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "ROLE")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type DatabaseRole =  
    class
        inherit ScriptNameObjectBase
        interface ISfcSupportsDesignMode
        interface IObjectPermission
        interface ICreatable
        interface IDroppable
        interface IAlterable
        interface IRenamable
        interface IExtendedProperties
        interface IScriptable
    end

public final class DatabaseRole extends ScriptNameObjectBase implements ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable

DatabaseRole 型別公開下列成員。

建構函式

	名稱	說明
	DatabaseRole() () () ()	Initializes a new instance of the DatabaseRole class.
	DatabaseRole(Database, String)	Initializes a new instance of the DatabaseRole class.

上層

屬性

	名稱	說明
	CreateDate	Gets the date and time when the database role was created.
	DateLastModified	Gets the date and time when the database role was last modified.
	ExecuteForScalar	取得或設定 Boolean 屬性值，指定物件是否設定為執行純量選項。 (繼承自 SqlSmoObject。)
	ExtendedProperties	Gets the extended properties of the database role.
	ID	Gets the ID value that uniquely identifies the database role.
	IsFixedRole	Gets the Boolean property value that specifies whether the database role is a fixed role or a user-defined role.
	IsTouched	取得 Boolean 屬性值，指定物件屬性是否已更新但尚未保存在伺服器上。 (繼承自 SqlSmoObject。)
	Name	Gets or sets a String value that specifies the name of the database role. (覆寫 NamedSmoObject. . :: . .Name。)
	ObjectInSpace	取得 Boolean 屬性值，指定物件是否存在於隔離中，或是直接或間接連接至 SQL Server 執行個體。 (繼承自 SqlSmoObject。)
	Owner	Gets or sets the owner of the database role.
	Parent	Gets or sets the Database object that is the parent of the DatabaseRole object.
	Properties	取得代表物件屬性的 Property 物件集合。 (繼承自 SqlSmoObject。)
	ScalarResult	取得受參考物件的純量結果。 (繼承自 SqlSmoObject。)
	State	Gets the state of the referenced object. (繼承自 SmoObjectBase。)
	Urn	取得可唯一識別物件的統一資源名稱 (URN) 位址值。 (繼承自 SqlSmoObject。)
	UserData	Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。)

上層

方法

	名稱	說明
	AddDatabaseContext(StringCollection)	將資料庫內容加入至以 queries 參數來識別的查詢集合。 (繼承自 SqlSmoObject。)
	AddDatabaseContext(StringCollection, ScriptingOptions)	將資料庫內容加入至以 queries 參數來識別的查詢集合，並使用指定的指令碼選項。 (繼承自 SqlSmoObject。)
	AddMember	Adds an existing database user or database role to the database role.
	Alter	Updates any DatabaseRole object property changes on the instance of Microsoft SQL Server.
	AlterImpl	啟動物件更改事件。 (繼承自 SqlSmoObject。)
	AlterImplFinish	物件更改事件完成時呼叫的方法。 (繼承自 SqlSmoObject。)
	AlterImplInit	初始化物件更改事件時呼叫的方法。 (繼承自 SqlSmoObject。)
	AlterImplWorker	呼叫 Alter 方法。 (繼承自 SqlSmoObject。)
	AppendCommaText	Appends text, optionally separated by a comma. (繼承自 ScriptNameObjectBase。)
	AppendWithCommaText	Appends text, optionally separated by a comma. (繼承自 ScriptNameObjectBase。)
	AppendWithOption	Appends text and option text separated from the main text with a “WITH” string and optionally separated by a comma. (繼承自 ScriptNameObjectBase。)
	AutoGenerateName	Generates a name based on the object Guid. (繼承自 ScriptNameObjectBase。)
	BindDefaultImpl	繫結參數所識別的預設項目。 (繼承自 SqlSmoObject。)
	BindRuleImpl	將規則結構描述繫結至參數所識別的規則和資料行。 (繼承自 SqlSmoObject。)
	CheckCollation	檢查 collationName 參數所識別之定序方法的指令碼選項順序。 (繼承自 SqlSmoObject。)
	CheckObjectDirty	Checks whether object has been modified and not persisted. (繼承自 ScriptNameObjectBase。)
	CheckObjectState() () () ()	驗證受參考物件的狀態。 (繼承自 SqlSmoObject。)
	CheckObjectState(Boolean)	驗證受參考物件的狀態，並以選項指定如果還未建立該物件則擲回例外狀況。 (繼承自 SqlSmoObject。)
	CheckObjectStateImpl	檢查 SqlSmoObject 的狀態。 (繼承自 SqlSmoObject。)
	CheckTextCorectness	Checks text for correctness against the parameters. (繼承自 ScriptNameObjectBase。)
	CheckTextModeSupport	Checks mode of support. (繼承自 ScriptNameObjectBase。)
	CheckVersion100	檢查 SQL Server 的版本是否為 SQL Server 2008。 (繼承自 SqlSmoObject。)
	CheckVersion80	檢查 SQL Server 2000 上物件的有效性。 (繼承自 SqlSmoObject。)
	CheckVersion80SP3	檢查 SQL Server 2000 SP3 上物件的有效性。 (繼承自 SqlSmoObject。)
	CheckVersion90	檢查 SQL Server 2005 上物件的有效性。 (繼承自 SqlSmoObject。)
	CheckVersionBelow90	檢查 SQL Server 的版本是否在 SQL Server 2005 之前。 (繼承自 SqlSmoObject。)
	CleanObject	Cleans the referenced object. (繼承自 ScriptNameObjectBase。)
	Create	Creates a database role on the instance of Microsoft SQL Server as defined by the DatabaseRole object.
	CreateImpl	使用指令碼選項建立物件。 (繼承自 SqlSmoObject。)
	CreateImplFinish	建立事件完成時呼叫的方法。 (繼承自 SqlSmoObject。)
	CreateImplInit	初始化建立事件時呼叫的方法。 (繼承自 SqlSmoObject。)
	Deny(ObjectPermissionSet, String)	Denies the specified set of permissions for the specified grantee on the database role.
	Deny(ObjectPermissionSet, array<String> [] () [] [])	Denies the specified set of permissions for the specified grantees on the database role.
	Deny(ObjectPermissionSet, String, Boolean)	Denies the specified set of permissions for the specified grantee and other users that the grantee granted the specified set of permissions on the database role.
	Deny(ObjectPermissionSet, array<String> [] () [] [], Boolean)	Denies the specified set of permissions for the specified grantees and other users that the grantee granted the specified set of permissions on the database role.
	Discover	探索 Object 類型的清單。 (繼承自 SqlSmoObject。)
	Drop	Drops the database role.
	DropImpl	卸除 SqlSmoObject。 (繼承自 SqlSmoObject。)
	DropImplWorker	呼叫 Drop 方法。 (繼承自 SqlSmoObject。)
	DropMember	Removes the specified database user or role from the referenced database role.
	EnumAgentProxyAccounts	Returns a list of agent proxy accounts that are assigned to the database role.
	EnumMembers	Returns a list of database users that are members of the database role.
	EnumObjectPermissions() () () ()	Returns a list of object permissions assigned to the referenced database role.
	EnumObjectPermissions(String)	Returns a list of object permissions assigned to the referenced database role for the specified member of the role.
	EnumObjectPermissions(ObjectPermissionSet)	Returns a list of object permissions assigned to the referenced database role for the specified set of object permissions.
	EnumObjectPermissions(String, ObjectPermissionSet)	Returns a list of object permissions assigned to the referenced database role for the specified member of the role and for the specified set of permissions.
	EnumRoles	Returns a list of the roles that the referenced database role is a member of.
	EnumScriptImpl	列舉 so 參數所指定的指令碼。 (繼承自 SqlSmoObject。)
	EnumScriptImplWorker	呼叫方法，用以列舉 so 參數所指定的指令碼。 (繼承自 SqlSmoObject。)
	EnumScriptImplWorkerSOChanged	傳回 IEnumerable 字串，描述物件的指令碼選項。 (繼承自 SqlSmoObject。)
	Equals	(繼承自 Object。)
	ExecuteNonQuery	(繼承自 SqlSmoObject。)
	Finalize	(繼承自 Object。)
	ForceTextModeOnTextBody	Enforces text mode on the text body. (繼承自 ScriptNameObjectBase。)
	FormatSqlVariant	將物件格式化為 SqlVariant 類型。 (繼承自 SqlSmoObject。)
	GenerateDataSpaceFileStreamScript	產生指令碼來建立資料檔案。 (繼承自 SqlSmoObject。)
	GenerateDataSpaceScript	產生指令碼來配置資料檔中的空間。 (繼承自 SqlSmoObject。)
	GetBindDefaultScript	取得指令碼，用以繫結由 defSchema 和 defName 參數所指定的預設值。 (繼承自 SqlSmoObject。)
	GetBindRuleScript	取得指令碼，用以指定繫結規則。 (繼承自 SqlSmoObject。)
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	指派 SqlSmoObject 的布林參數。 (繼承自 SqlSmoObject。)
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	指派 SqlSmoObject 的布林屬性。 (繼承自 SqlSmoObject。)
	GetBraketNameForText	Gets the bracket name. (繼承自 ScriptNameObjectBase。)
	GetDateTimeParameter	指派 SqlSmoObject 的日期時間屬性。 (繼承自 SqlSmoObject。)
	GetDateTimeParameterAsInt	如果 SqlSmoObject 的日期時間屬性不是 null，則將該日期時間屬性指派為整數值。 (繼承自 SqlSmoObject。)
	GetDBName	取得與物件相關聯的資料庫名稱。 (繼承自 SqlSmoObject。)
	GetEnumParameter	指派 SqlSmoObject 的列舉屬性。 (繼承自 SqlSmoObject。)
	GetFragOptionString	取得以字串值表示的 FragmentationOption 物件。 (繼承自 SqlSmoObject。)
	GetGuidParameter	指派 SqlSmoObject 的 Guid 屬性。 (繼承自 SqlSmoObject。)
	GetHashCode	(繼承自 Object。)
	GetIsSystemNamed	Gets a Boolean value that specifies whether the system is named. (繼承自 ScriptNameObjectBase。)
	GetIsTextDirty	Determines whether the text value is consistent with stored value. (繼承自 ScriptNameObjectBase。)
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	指派 SqlSmoObject 的參數。 (繼承自 SqlSmoObject。)
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	指派 SqlSmoObject 的參數。 (繼承自 SqlSmoObject。)
	GetPropValue	取得 SqlSmoObject 物件的屬性值。 (繼承自 SqlSmoObject。)
	GetPropValueOptional	取得 SqlSmoObject 物件的屬性值。 (繼承自 SqlSmoObject。)
	GetPropValueOptionalAllowNull	取得 SqlSmoObject 物件的屬性值。 (繼承自 SqlSmoObject。)
	GetRealValue	取得 SqlSmoObject 物件的屬性值。 (繼承自 SqlSmoObject。)
	GetScriptIncludeExists	Gets the script including the test for existence of type being scripted. (繼承自 ScriptNameObjectBase。)
	GetScriptingOptionsForCreate	取得 SqlSmoObject 物件的 ScriptingOptions。 (繼承自 SqlSmoObject。)
	GetServerName	取得物件相關聯之 SQL Server 執行個體的名稱。 (繼承自 SqlSmoObject。)
	GetServerObject	取得 SqlSmoObject 物件的伺服器。 (繼承自 SqlSmoObject。)
	GetSqlServerVersionName	取得物件相關聯之 SQL Server 執行個體的版本名稱。 (繼承自 SqlSmoObject。)
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	指派 SqlSmoObject 物件的字串參數。 (繼承自 SqlSmoObject。)
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	指派 SqlSmoObject 物件的字串參數。 (繼承自 SqlSmoObject。)
	GetTextBody() () () ()	Returns the text body. (繼承自 ScriptNameObjectBase。)
	GetTextBody(Boolean)	Returns the text body. (繼承自 ScriptNameObjectBase。)
	GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [])	Gets the text for scripting. (繼承自 ScriptNameObjectBase。)
	GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean)	Gets the text of script object. (繼承自 ScriptNameObjectBase。)
	GetTextHeader	Returns the text header. (繼承自 ScriptNameObjectBase。)
	GetTextMode	Determines whether the script name is using text mode. (繼承自 ScriptNameObjectBase。)
	GetTextProperty(String)	Gets the property as text. (繼承自 ScriptNameObjectBase。)
	GetTextProperty(String, ScriptingOptions)	Gets the property as text. (繼承自 ScriptNameObjectBase。)
	GetTimeSpanParameterAsInt	指派 SqlSmoObject 物件的時間範圍參數。 (繼承自 SqlSmoObject。)
	GetType	(繼承自 Object。)
	GetUrnRecursive(StringBuilder)	指派 SqlSmoObject 物件的 Urn 物件。 (繼承自 SqlSmoObject。)
	GetUrnRecursive(StringBuilder, UrnIdOption)	指派 SqlSmoObject 物件的 Urn 物件。 (繼承自 SqlSmoObject。)
	Grant(ObjectPermissionSet, String)	Grants the specified set of permissions to the specified grantee on the database role.
	Grant(ObjectPermissionSet, array<String> [] () [] [])	Grants the specified set of permissions to the specified grantees on the database role.
	Grant(ObjectPermissionSet, String, Boolean)	Grants access to the specified permission to the grantee and the ability to grant access to other users on the database role.
	Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean)	Grants access to the specified permission to the grantees and the ability to grant access to other users on the database role.
	Grant(ObjectPermissionSet, String, Boolean, String)	Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the database role under an assumed role.
	Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean, String)	Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the database role under an assumed role.
	ImplInitialize	初始化 SqlSmoObject 物件的欄位。 (繼承自 SqlSmoObject。)
	Initialize() () () ()	初始化物件，並強制載入屬性。 (繼承自 SqlSmoObject。)
	Initialize(Boolean)	初始化物件，並強制載入屬性。 (繼承自 SqlSmoObject。)
	IsObjectDirty	Determines whether the referenced object is consistent with the stored object. (繼承自 ScriptNameObjectBase。)
	IsObjectInitialized	驗證物件是否已初始化。 (繼承自 SqlSmoObject。)
	IsObjectInSpace	驗證物件是否已隔離，或是連接至 SQL Server 的執行個體。 (繼承自 SqlSmoObject。)
	IsVersion80SP3	判斷 SQL Server 的版本是否為 SQL Server 2000 SP3。 (繼承自 SqlSmoObject。)
	IsVersion90AndAbove	判斷 SQL Server 的版本是否為 SQL Server 2005 或更新版本。 (繼承自 SqlSmoObject。)
	MarkDropped	設定卸除 SqlSmoState。 (繼承自 SqlSmoObject。)
	MarkForDropImpl	設定卸除 SqlSmoState。 (繼承自 SqlSmoObject。)
	MemberwiseClone	(繼承自 Object。)
	PostAlter	SqlSmoObject 更改後啟動的方法。 (繼承自 SqlSmoObject。)
	PostCreate	SqlSmoObject 建立後啟動的方法。 (繼承自 SqlSmoObject。)
	PostDrop	SqlSmoObject 卸除後啟動的方法。 (繼承自 SqlSmoObject。)
	Refresh	Refreshes the script name. (繼承自 ScriptNameObjectBase。)
	Rename	Renames the database role.
	RenameImpl	僅供參考之用。不支援。我們無法保證未來的相容性。 (繼承自 NamedSmoObject。)
	RenameImplWorker	僅供參考之用。不支援。我們無法保證未來的相容性。 (繼承自 NamedSmoObject。)
	Revoke(ObjectPermissionSet, String)	Revokes a previously granted set of permissions from a grantee on the database role.
	Revoke(ObjectPermissionSet, array<String> [] () [] [])	Revokes a previously granted set of permissions from a list of grantees on the database role.
	Revoke(ObjectPermissionSet, String, Boolean, Boolean)	Revokes previously granted permissions from a grantee on the database role and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
	Revoke(ObjectPermissionSet, array<String> [] () [] [], Boolean, Boolean)	Revokes previously granted permissions from grantees on the database role and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
	Revoke(ObjectPermissionSet, String, Boolean, Boolean, String)	Revokes previously granted permissions from a grantee on the database role and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
	Revoke(ObjectPermissionSet, array<String> [] () [] [], Boolean, Boolean, String)	Revokes previously granted permissions from grantees on the database role and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
	Script() () () ()	Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server database role.
	Script(ScriptingOptions)	Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server database role as specified by the scripting options.
	ScriptAlter	根據參數來更改 SqlSmoObject。 (繼承自 SqlSmoObject。)
	ScriptAnsiQI	Scripts the database object in ANSI text. (繼承自 ScriptNameObjectBase。)
	ScriptChangeOwner	This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
	ScriptCreate	根據參數來更改 SqlSmoObject。 (繼承自 SqlSmoObject。)
	ScriptDdl	擲回 InvalidSmoOperationException。 (繼承自 SqlSmoObject。)
	ScriptDrop	擲回 InvalidSmoOperationException。 (繼承自 SqlSmoObject。)
	ScriptImpl() () () ()	取得 SqlSmoObject 指令碼的集合。 (繼承自 SqlSmoObject。)
	ScriptImpl(ScriptingOptions)	取得 SqlSmoObject 指令碼的集合。 (繼承自 SqlSmoObject。)
	ScriptImplWorker	取得 SqlSmoObject 指令碼的集合。 (繼承自 SqlSmoObject。)
	ScriptInformativeHeaders	Scripts the information headers. (繼承自 ScriptNameObjectBase。)
	ScriptOwner	Alters the script owner authorization. (繼承自 NamedSmoObject。)
	ScriptRename	This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。)
	SetCollectionTextMode	Sets the collection text mode. (繼承自 ScriptNameObjectBase。)
	SetIsSystemNamed	Sets a Boolean value that specifies whether the system is named. (繼承自 ScriptNameObjectBase。)
	SetParentImpl	將 SqlSmoObject 的父系設定為 newParent 參數。 (繼承自 SqlSmoObject。)
	SetSchemaOwned	Sets the schema owned value. (繼承自 NamedSmoObject。)
	SetTextBody	Specifies the text body. (繼承自 ScriptNameObjectBase。)
	SetTextHeader	Specifies the text header. (繼承自 ScriptNameObjectBase。)
	SetTextMode	Specifies the text mode. (繼承自 ScriptNameObjectBase。)
	SwitchTextMode	Switches the text mode. (繼承自 ScriptNameObjectBase。)
	ThrowIfTextIsDirtyForAlter	Throws an exception of text has been modified and not persisted. (繼承自 ScriptNameObjectBase。)
	ToString	傳回代表受參考物件的 String。 (繼承自 SqlSmoObject。)
	TouchImpl	未實作。 (繼承自 SqlSmoObject。)
	UnbindDefaultImpl	將 SqlSmoObject 的預設資料行解除繫結。 (繼承自 SqlSmoObject。)
	UnbindRuleImpl	將 SqlSmoObject 的規則解除繫結。 (繼承自 SqlSmoObject。)
	Validate	Validates the state of an object. (繼承自 SmoObjectBase。)

上層

事件

	名稱	說明
	PropertyChanged	代表屬性變更時所發生的事件。 (繼承自 SqlSmoObject。)
	PropertyMetadataChanged	代表屬性中繼資料變更時所發生的事件。 (繼承自 SqlSmoObject。)

上層

欄位

	名稱	說明
	m_ExtendedProperties	代表屬性，此屬性定義為擴充 SqlSmoObject 所提供的屬性。 (繼承自 SqlSmoObject。)
	singletonParent	代表單一父代。 (繼承自 SqlSmoObject。)

上層

明確 繼承 實作

	名稱	說明
	IAlienObject. . :: . .Discover	探索任何相依性。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .GetDomainRoot	傳回網域的根目錄。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .GetParent	取得此物件的父系。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .GetPropertyType	取得指定的屬性類型。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .GetPropertyValue	取得指定的屬性值。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .GetUrn	取得物件的統一資源名稱。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .Resolve	取得執行個體，其中包含物件統一資源名稱之物件的相關資訊。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .SetObjectState	將物件狀態設定為指定的 SfcObjectState 值。 (繼承自 SqlSmoObject。)
	IAlienObject. . :: . .SetPropertyValue	設定屬性值。 (繼承自 SqlSmoObject。)
	ISfcPropertyProvider. . :: . .GetPropertySet	取得此物件屬性集的介面參考。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。)
	ISfcSupportsDesignMode. . :: . .IsDesignMode	Gets a Boolean value that specifies whether the database role supports design mode.

上層

備註

To get DatabaseRole object properties, users can be a member of the public fixed server role.

To set DatabaseRole object properties, users must have ALTER permission on the database role.

To create a database role, users must have CREATE ROLE permission on the parent database.

To drop a database role, users must have ALTER ANY ROLE permission on the parent database.

To add or remove members from the database role, users must be members of the db_owner or db_security admin fixed database role.

To grant, deny, or revoke permission on the database for other users, users must have CONTROL permission on the database role.

Thread Safety

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。

範例

管理使用者、角色和登入

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

管理使用者、角色和登入

資料庫層級角色

CREATE ROLE (Transact-SQL)