Name
DROP ROLE
Synopsis
This command destroys a named set of user privileges in the current user database.
Vendor |
Command |
---|---|
SQL Server |
Not supported |
MySQL |
Not supported |
Oracle |
Supported, with variations |
PostgreSQL |
Not supported |
SQL99 Syntax and Description
DROP ROLE role_name
The DROP ROLE
command destroys the specified
role. Only users who have WITH ADMIN OPTION
may
drop roles.
Oracle Syntax
DROP ROLE [owner_name.]role_name;
Executing the DROP ROLE
command destroys the
role in the current user database. It is no longer usable by any
users or roles who previously had the role assigned to them.
Get SQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.