December 2000
Intermediate to advanced
224 pages
9h 52m
English
DROP ROLE
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 |
DROP ROLE role_name
The DROP ROLE command destroys the specified
role. Only users who have WITH ADMIN OPTION may
drop roles.
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.