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.