Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: access privileges: grant select on (all current and future tables)?
- From: "John D. Burger" <john(at)mitre(dot)org>
- To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: access privileges: grant select on (all current and future tables)?
- Date: Fri, 28 Sep 2007 10:43:21 -0400
John Smith wrote:
and "grant usage on new tables in schema..." doesn't exist yet. which leads to my next question (see http://svr5.postgresql.org/pgsql-hackers/2005-01/msg01070.php)- are we there yet?
If I understand your question, you cannot grant "anticipatory" privileges to tables which do not yet exist, which I discovered in this thread:
http://archives.postgresql.org/pgsql-general/2007-02/msg00911.phpIf you follow the thread, you'll find that one reply pointed to some existing functions for managing this stuff. I found these useful.
- John D. Burger MITRE
- References:
- access privileges: grant select on (all current and future tables)?
- From: John Smith
- Re: access privileges: grant select on (all current and future tables)?
- From: John Smith
- access privileges: grant select on (all current and future tables)?
- Prev by Date: Re: question about pg_dump -a
- Next by Date: problemas zona horaria
- Previous by thread: Re: access privileges: grant select on (all current and future tables)?
- Next by thread: Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
- Indexes: