Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 25 of 26
Use the DROP
ROLE
statement to remove a role from the database. When you drop a role, Oracle revokes it from all users and roles to whom it has been granted and removes it from the database. User sessions in which the role is already enabled are not affected. However, no new user session can enable the role after it is dropped.
See Also:
|
You must have been granted the role with the ADMIN
OPTION
or you must have the DROP
ANY
ROLE
system privilege.
drop_role::=
drop_role
Specify the name of the role to be dropped.
To drop the role dw_manager
(created in "CREATE ROLE Example"), issue the following statement:
DROP ROLE dw_manager;
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|