DropMember Method

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The DropMember method removes the specified Microsoft SQL Server user, database role, or login from the role referenced.

구문

object
.DropMember(
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 DropMember(SQLDMO_LPCSTR NewValue);

주의

Configuring role membership by using the DropMember method of the Database and ServerRole objects requires appropriate permission.

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 from which the specified login will be dropped.

Applies To:

DatabaseRole Object

ServerRole Object