Re: Default permissions of system catalogs - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Default permissions of system catalogs
Date
Msg-id 200201081858.g08Iw6912221@candle.pha.pa.us
Whole thread Raw
In response to Re: Default permissions of system catalogs  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-hackers
> > Objections?
> 
> I assume you are proposing the same privileges that you describe for a user
> table (i.e. by default only the owner (==superuser) has any access)?
> 
> If so, this would break pgAdmin for any users who are not the superuser on
> their system as the majority of it's operation relies on examining the
> system catalogues. In this case I would *strongly* object.
> 
> <thinks...> Surely this would also be the case for psql though - have I
> misunderstood something?

I assumed he was saying that the contents of pg_class permissions should
be interpreted the same whether it is a system table or not.  He would
set the proper system table permissions so they are visible to all users
like it is now.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Ulrich Neumann"
Date:
Subject: Antw: Re: GETTIMEOFDAY_1ARG change
Next
From: Barry Lind
Date:
Subject: Re: JDBC: why is PGobject class instead of interface?