REVOKE { revoke_system_privileges
| revoke_object_privileges
} ;
revoke_system_privileges::=
{ system_privilege
| role
| ALL PRIVILEGES
}
[, { system_privilege
| role
| ALL PRIVILEGES
}
]...
FROM grantee_clause
revoke_object_privileges::=
{ object_privilege | ALL [ PRIVILEGES ] }
[, { object_privilege | ALL [ PRIVILEGES ] } ]...
on_object_clause
FROM grantee_clause
[ CASCADE CONSTRAINTS | FORCE ]
grantee_clause::=
{ user [ IDENTIFIED BY password ]
| role
| PUBLIC
}
[, { user [ IDENTIFIED BY password ]
| role
| PUBLIC
}
]...
on_object_clause::=
ON { [ schema. ] object
| DIRECTORY directory_name
| EDITION edition_name
| MINING MODEL [schema.] mining_model_name
| JAVA { SOURCE | RESOURCE } [ schema. ] object
}
Example
REVOKE DROP ANY TABLE
FROM hr, oe;
REVOKE dw_manager
FROM sh;
REVOKE CREATE TABLESPACE
FROM dw_manager;
REVOKE dw_user
FROM dw_manager;
GRANT ALL
ON orders TO hr;