• B
    I have large database and with this DB work more users and I very need · 85add42a
    Bruce Momjian 提交于
    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
    85add42a
creatinh.c 17.4 KB