|
|
|
|
|
|
Revokes privileges on a 
table 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 ]
{ { SELECT | INSERT | UPDATE | DELETE | REFERENCES } [,...]
| ALL [ PRIVILEGES ]
}
ON [ TABLE ] tablename [, ...]
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. |
SELECT |
See GRANT (Table). |
INSERT |
|
UPDATE |
|
DELETE |
|
REFERENCES |
|
ALL |
|
PRIVILEGES |
|
tablename |
|
username |
|
PUBLIC |