共用方式為

AddMember Method

  • 發行項

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The AddMember method assigns Microsoft SQL Server database or server role membership to the specified user, database role, or login.

語法

object
.AddMember(
User
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • User
    For the DatabaseRole object, a string that specifies an existing database user or role by name. For the ServerRole object, a string that specifies an existing SQL Server login by name.

Prototype (C/C++)

HRESULT AddMember(SQLDMO_LPCSTR NewValue);

備註

Configuring role membership by using the AddMember method of the Database and ServerRole objects requires appropriate permissions.

For the Database object, the database user mapped to the SQL Server login used for SQLServer object connection must be a member of the fixed database role db_owner.

For the ServerRole object, the SQL Server login used for SQLServer object connection must be a member of the role to which the specified login will be added.

Applies to:

DatabaseRole Object

ServerRole Object