granting SELECT on _all_ database objects (even non existing objects)

From: Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: granting SELECT on _all_ database objects (even non existing objects)
Date: 2007-01-03 15:01:37
Message-ID: 1167836497.31315.93.camel@azagthot.critical.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

my database contains a big table. on this table I create VIEWs.

The problem is this: the VIEWs are created dinamically by an external
program (depending on some configurations). Nevertheless I would like to
GRANT SELECT priviliges to my readOnlyUser, in a simple way...!!!

Summary: is it possible to allow Read-Onlky access to some user, in some
database, even if new database objects (VIEWs in my case) are created
dinamically ???

something like
GRANT SELECT ON * TO readOnlyUser;

I'm confused..

thx
jmf

DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the individual(s) named. If you are not a named addressee and mistakenly received this message you should not copy or otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are not guaranteed to be secure or without errors as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. Therefore, the sender does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard copy version if verification is required. Critical Software, SA.

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2007-01-03 15:04:57 Re: "no unpinned buffers available" ? why? (hstore and plperl involved)
Previous Message Tom Lane 2007-01-03 14:52:43 Re: superuser authentication?