sp_dropapprole (Transact-SQL)
Applies to: SQL Server
Removes an application role from the current database.
Important
This feature will be removed in a future version of 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.
Transact-SQL syntax conventions
Syntax
sp_dropapprole [ @rolename = ] N'rolename'
[ ; ]
Arguments
[ @rolename = ] N'rolename'
The application role to remove. @rolename is sysname, with no default. @rolename 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 can't be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.
sp_dropapprole
can't 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';
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για