|
|
|
|
|
|
Revokes privileges on a 
schema from a user.
In a database with trust authentication, the GRANT and REVOKE statements appear to work as expected but have no actual effect on the security of the database.
Syntax
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | USAGE } [,...]
| ALL [ PRIVILEGES ]
}
ON SCHEMA schema-name [, ...]
FROM { username | PUBLIC } [, ...]
Semantics
GRANT OPTION FOR |
revokes the grant option for the privilege, not the privilege itself. If omitted, revokes both the privilege and the grant option. |
CREATE |
See GRANT (Schema).
|
USAGE |
|
ALL |
|
PRIVILEGES |
|
schema-name |
|
username |
|
PUBLIC |