|
|
|
|
|
|
|
|
|
|
version 11.3
REVOKE [READ | READ_WRITE | ALL] ON sql_name
Description
The REVOKE command can be used to remove specific access rights associated with the schema set by the sql_name parameter.
In fact, when you execute this command, you assign the <Nobody> pseudo-group of users to the specified access right.
Example
You want to delete all read-write access rights to the MySchema1 schema:
REVOKE
READ_WRITE ON MySchema1
See Also
|
|
|
|
|
|
|
|
|
|