sp_dropapprole (Transact-SQL)

Removes an application role from the current database.

Important

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use DROP APPLICATION ROLE instead.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_dropapprole [@rolename = ] 'role'

Arguments

  • [ @rolename = ] 'role'
    Is the application role to remove. role is a sysname, with no default. role must exist in the current database.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropapprole can only be used to remove application roles. If a role owns any securables, the role cannot be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.

sp_dropapprole cannot be executed within a user-defined transaction.

Permissions

Requires ALTER ANY APPLICATION ROLE permission on the database.

Examples

The following example removes the SalesApp application role from the current database.

EXEC sp_dropapprole 'SalesApp'

See Also

Reference

Security Stored Procedures (Transact-SQL)
sp_addapprole (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
sp_changeobjectowner (Transact-SQL)
sp_setapprole (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance