diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-21 00:26:44 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-21 00:26:44 +0000 |
| commit | b0bcf8aab2da6710ff8842b86fed93571e143cc8 (patch) | |
| tree | 922f5b76b34a555d1a30003f216dd5df1aa3663c /doc/src/sgml/ref/revoke.sgml | |
| parent | ad201b8d18b19d8c7a4a458e078bb555fcc2de74 (diff) | |
| download | postgresql-b0bcf8aab2da6710ff8842b86fed93571e143cc8.tar.gz postgresql-b0bcf8aab2da6710ff8842b86fed93571e143cc8.zip | |
Restructure AclItem representation so that we can have more than eight
different privilege bits (might as well make use of the space we were
wasting on padding). EXECUTE and USAGE bits for procedures, languages
now are separate privileges instead of being overlaid on SELECT. Add
privileges for namespaces and databases. The GRANT and REVOKE commands
work for these object types, but we don't actually enforce the privileges
yet...
Diffstat (limited to 'doc/src/sgml/ref/revoke.sgml')
| -rw-r--r-- | doc/src/sgml/ref/revoke.sgml | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index 60c31a37c8d..3bc30cfd49a 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.21 2002/02/21 22:39:36 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.22 2002/04/21 00:26:42 tgl Exp $ PostgreSQL documentation --> @@ -18,7 +18,11 @@ PostgreSQL documentation <synopsis> REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } - ON [ TABLE ] <replaceable class="PARAMETER">object</replaceable> [, ...] + ON [ TABLE ] <replaceable class="PARAMETER">tablename</replaceable> [, ...] + FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + +REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } + ON DATABASE <replaceable>dbname</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] REVOKE { EXECUTE | ALL [ PRIVILEGES ] } @@ -28,6 +32,10 @@ REVOKE { EXECUTE | ALL [ PRIVILEGES ] } REVOKE { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE <replaceable>langname</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + +REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } + ON SCHEMA <replaceable>schemaname</replaceable> [, ...] + FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] </synopsis> </refsynopsisdiv> |