Thread: pgsql/src/include/catalog (catversion.h pg_attribute.h pg_class.h pg_shadow.h)
pgsql/src/include/catalog (catversion.h pg_attribute.h pg_class.h pg_shadow.h)
From
Bruce Momjian - CVS
Date:
Date: Friday, June 9, 2000 @ 11:51:00 Author: momjian Update of /home/projects/pgsql/cvsroot/pgsql/src/include/catalog from hub.org:/home/projects/pgsql/tmp/cvs-serv8015/pgsql/src/include/catalog Modified Files: catversion.h pg_attribute.h pg_class.h pg_shadow.h ----------------------------- Log Message ----------------------------- I have large database and with this DB work more users and I very need more restriction for fretful users. The current PG allow define only NO-CREATE-DB and NO-CREATE-USER restriction, but for some users I need NO-CREATE-TABLE and NO-LOCK-TABLE. This patch add to current code NOCREATETABLE and NOLOCKTABLE feature: CREATE USER username [ WITH [ SYSID uid ] [ PASSWORD 'password' ] ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] -> [ CREATETABLE | NOCREATETABLE ] [ LOCKTABLE | NOLOCKTABLE ] ...etc. If CREATETABLE or LOCKTABLE is not specific in CREATE USER command, as default is set CREATETABLE or LOCKTABLE (true). A user with NOCREATETABLE restriction can't call CREATE TABLE or SELECT INTO commands, only create temp table is allow for him. Karel