Re: [HACKERS] Postgres acl (fwd) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Postgres acl (fwd)
Date
Msg-id 199801070223.VAA08318@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Postgres acl (fwd)  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
> >
> > IMHO, the system tables should _never_ be directly modifiable by anyone
> > other than the superuser/dba.  The rest of the population should have to
> > use a command of some sort that can be grant/revoked by said superuser/dba.
>
> Are there any maintenance operations which require a "delete from pg_xxx"? If
> not, then we could just modify the parser (or the executor?) to check the table
> name and not allow insert/delete from any table whose name starts with "pg_". Had
> to ask, although I'm sure this is too easy to actually work :)

Interesting thought.  Wonder if it would work?

--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: [COMMITTERS] 'pgsql/src/interfaces/odbc/src/socket compat.h connect.h connectp.cpp errclass.cpp errclass.h sockio.cpp sockio.h wO (fwd)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Postgres acl (fwd)