]> granicus.if.org Git - postgresql/commit
I have large database and with this DB work more users and I very need
authorBruce Momjian <bruce@momjian.us>
Fri, 9 Jun 2000 15:51:02 +0000 (15:51 +0000)
committerBruce Momjian <bruce@momjian.us>
Fri, 9 Jun 2000 15:51:02 +0000 (15:51 +0000)
commit85add42a570cdb4be2d674e62535eb54b4dcd5cf
treedbf157f4e38ff97df572bda2244d7280338bf541
parenta672e9650abcc9a08df06dd075a884543f3d87f3
 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
13 files changed:
src/backend/commands/command.c
src/backend/commands/creatinh.c
src/backend/commands/user.c
src/backend/parser/gram.y
src/backend/parser/keywords.c
src/backend/tcop/pquery.c
src/bin/initdb/initdb.sh
src/bin/scripts/createuser
src/include/catalog/catversion.h
src/include/catalog/pg_attribute.h
src/include/catalog/pg_class.h
src/include/catalog/pg_shadow.h
src/include/nodes/parsenodes.h