User 類別
The User object represents a SQL Server user.
繼承階層
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..::..User
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class User _
Inherits ScriptNameObjectBase _
Implements ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, _
IAlterable, IRenamable, IExtendedProperties, IScriptable, IUserOptions, _
IDmfFacet
'用途
Dim instance As User
[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public sealed class User : ScriptNameObjectBase, ISfcSupportsDesignMode,
IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable,
IExtendedProperties, IScriptable, IUserOptions, IDmfFacet
[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public ref class User sealed : public ScriptNameObjectBase,
ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable,
IRenamable, IExtendedProperties, IScriptable, IUserOptions, IDmfFacet
[<SealedAttribute>]
[<PhysicalFacetAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
type User =
class
inherit ScriptNameObjectBase
interface ISfcSupportsDesignMode
interface IObjectPermission
interface ICreatable
interface IDroppable
interface IAlterable
interface IRenamable
interface IExtendedProperties
interface IScriptable
interface IUserOptions
interface IDmfFacet
end
public final class User extends ScriptNameObjectBase implements ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable, IUserOptions, IDmfFacet
User 型別公開下列成員。
建構函式
名稱 | 說明 | |
---|---|---|
![]() |
User() () () () | Initializes a new instance of the User class. |
![]() |
User(Database, String) | Initializes a new instance of the User class on the specified database with the specified name. |
上層
屬性
名稱 | 說明 | |
---|---|---|
![]() |
AsymmetricKey | Gets or sets the asymmetric key for the user. |
![]() |
Certificate | Gets or sets the certificate for the user. |
![]() |
CreateDate | Gets the date and time when the database user was created. |
![]() |
DateLastModified | Gets the date and time when the database user was last modified. |
![]() |
DefaultSchema | Gets the default schema for the database user. |
![]() |
Events | Gets the events that are associated with the database user. |
![]() |
ExecuteForScalar | 取得或設定 Boolean 屬性值,指定物件是否設定為執行純量選項。 (繼承自 SqlSmoObject。) |
![]() |
ExtendedProperties | Gets the extended properties of the database user. |
![]() |
HasDBAccess | Gets the Boolean property that specifies whether the database user has access to the database. |
![]() |
ID | Gets the ID value that uniquely identifies the database user. |
![]() |
IsSystemObject | Gets the Boolean property that specifies whether the database user is a system object. |
![]() |
IsTouched | 取得 Boolean 屬性值,指定物件屬性是否已更新但尚未保存在伺服器上。 (繼承自 SqlSmoObject。) |
![]() |
Login | Gets the login that is associated with the database user. |
![]() |
LoginType | Gets the type of login that is associated with the database user, such as whether it is a Windows group or a SQL Server standard login. |
![]() |
Name | Gets or sets a String value that specifies the name of the user. (覆寫 NamedSmoObject. . :: . .Name。) |
![]() |
ObjectInSpace | 取得 Boolean 屬性值,指定物件是否存在於隔離中,或是直接或間接連接至 SQL Server 執行個體。 (繼承自 SqlSmoObject。) |
![]() |
Parent | Gets the Database object that is the parent of the User object. |
![]() |
Properties | 取得代表物件屬性的 Property 物件集合。 (繼承自 SqlSmoObject。) |
![]() |
ScalarResult | 取得受參考物件的純量結果。 (繼承自 SqlSmoObject。) |
![]() |
Sid | Gets the security identification number (SID) value of the database user. |
![]() |
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。) |
![]() |
UserType | Gets or sets the type of user. |
上層
方法
名稱 | 說明 | |
---|---|---|
![]() |
AddDatabaseContext(StringCollection) | 將資料庫內容加入至以 queries 參數來識別的查詢集合。 (繼承自 SqlSmoObject。) |
![]() |
AddDatabaseContext(StringCollection, ScriptingOptions) | 將資料庫內容加入至以 queries 參數來識別的查詢集合,並使用指定的指令碼選項。 (繼承自 SqlSmoObject。) |
![]() |
AddToRole | Adds the database user to the specified role. |
![]() |
Alter | Updates any User 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 user on the instance of SQL Server as defined by the User object. |
![]() |
CreateImpl | 使用指令碼選項建立物件。 (繼承自 SqlSmoObject。) |
![]() |
CreateImplFinish | 建立事件完成時呼叫的方法。 (繼承自 SqlSmoObject。) |
![]() |
CreateImplInit | 初始化建立事件時呼叫的方法。 (繼承自 SqlSmoObject。) |
![]() |
Deny(ObjectPermissionSet, String) | Denies access to the specified permission for the specified grantee on the database user. |
![]() |
Deny(ObjectPermissionSet, array<String> [] () [] []) | Denies access to the specified permission for the specified grantees on the database user. |
![]() |
Deny(ObjectPermissionSet, String, Boolean) | Denies access to the specified permission for the specified grantee and other users whom the grantee granted access on the database user. |
![]() |
Deny(ObjectPermissionSet, array<String> [] () [] [], Boolean) | Denies access to the specified permission for the specified grantees on the database user. |
![]() |
Discover | 探索 Object 類型的清單。 (繼承自 SqlSmoObject。) |
![]() |
Drop | Removes the user from the database. |
![]() |
DropImpl | 卸除 SqlSmoObject。 (繼承自 SqlSmoObject。) |
![]() |
DropImplWorker | 呼叫 Drop 方法。 (繼承自 SqlSmoObject。) |
![]() |
EnumObjectPermissions() () () () | Enumerates a list of object permissions for the database user. |
![]() |
EnumObjectPermissions(String) | Enumerates a list of object permissions for a specified grantee on the database user. |
![]() |
EnumObjectPermissions(ObjectPermissionSet) | Enumerates a list of object permissions for a specified permission on the database user. |
![]() |
EnumObjectPermissions(String, ObjectPermissionSet) | Enumerates a list of object permissions for a specified grantee and a specified permission on the database user. |
![]() |
EnumOwnedObjects | Enumerates a list of object that the database user owns. |
![]() |
EnumRoles | Enumerates a list of roles of which the database user is a member. |
![]() |
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 access to the specified permission for the specified grantee on the database user. |
![]() |
Grant(ObjectPermissionSet, array<String> [] () [] []) | Grants access to the specified permission for the specified grantees on the database user. |
![]() |
Grant(ObjectPermissionSet, String, Boolean) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the database user. |
![]() |
Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean) | Grants access to the specified permission and the ability to grant access to other users for the specified grantees on the database user. |
![]() |
Grant(ObjectPermissionSet, String, Boolean, String) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the database user. |
![]() |
Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean, String) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the database user under an assumed role. |
![]() |
ImplInitialize | 初始化 SqlSmoObject 物件的欄位。 (繼承自 SqlSmoObject。) |
![]() |
Initialize() () () () | 初始化物件,並強制載入屬性。 (繼承自 SqlSmoObject。) |
![]() |
Initialize(Boolean) | 初始化物件,並強制載入屬性。 (繼承自 SqlSmoObject。) |
![]() |
IsMember | Verifies whether the database user is a member of the specified role. |
![]() |
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 user. |
![]() |
RenameImpl | 僅供參考之用。不支援。我們無法保證未來的相容性。 (繼承自 NamedSmoObject。) |
![]() |
RenameImplWorker | 僅供參考之用。不支援。我們無法保證未來的相容性。 (繼承自 NamedSmoObject。) |
![]() |
Revoke(ObjectPermissionSet, String) | Revokes previously granted permissions from a grantee on the database user. |
![]() |
Revoke(ObjectPermissionSet, array<String> [] () [] []) | Revokes previously granted permissions from a list of grantees on the database user. |
![]() |
Revoke(ObjectPermissionSet, String, Boolean, Boolean) | Revokes previously granted permissions from a grantee on the database user and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access. |
![]() |
Revoke(ObjectPermissionSet, array<String> [] () [] [], Boolean, Boolean) | Revokes previously granted permissions from the grantees on the database user and any other users to whom the grantees have granted access. The grantees are also given the ability to revoke other users' access. |
![]() |
Revoke(ObjectPermissionSet, String, Boolean, Boolean, String) | Revokes previously granted permissions from a grantee on the database user and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access under an assumed role. |
![]() |
Revoke(ObjectPermissionSet, array<String> [] () [] [], Boolean, Boolean, String) | Revokes previously granted permissions from grantees on the database user and any other users to whom the grantees have granted access. The grantees are also given the ability to revoke other users' access under an assumed role. |
![]() |
Script() () () () | Generates a Transact-SQL script that can be used to re-create the database user. |
![]() |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the database user as specified by the script 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 user supports design mode. |
上層
備註
To get User object properties, users can be a member of the public fixed server role.
To set User object properties, uses must have ALTER ANY USER permission on the database or be a member of the db_owner fixed database role.
To change the default schema, users must have ALTER permission on the specified user or be the owner of the user.
To create or drop a user, users must have ALTER ANY USER permission on the fixed server role or be a member of the db_owner fixed database role.
To grant, deny, or revoke permission on the specified user to other users, users must have CONTROL permission on the specified user.
Thread Safety
此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。