Skip to Main Content
SQL in a Nutshell
book

SQL in a Nutshell

by Kevin Kline
December 2000
Intermediate to advanced content levelIntermediate to advanced
224 pages
9h 52m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

Kevin Kline

Publisher Resources

ISBN: 1565927443