how do I grant select to one user for all tables in a DB?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how do I grant select to one user for all tables in a DB?
Date: 2012-12-05 03:12:46
Message-ID: 0AD01C53605506449BA127FB8B99E5E13E11699D@FMSMSX105.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

V9.1.5 on linux

User "select" created (yup, that's right, they want the user name to be "select". Guess what ptivs it is to have! Don't kill the messanger :-) )

postgres=# grant select on all tables in schema sde to "select";
ERROR: schema "sde" does not exist
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+---------+-------------+---------------------
postgres | pgdbadm | UTF8 | C | en_US.UTF-8 |
sde | pgdbadm | UTF8 | C | en_US.UTF-8 |
template0 | pgdbadm | UTF8 | C | en_US.UTF-8 | =c/pgdbadm +
| | | | | pgdbadm=CTc/pgdbadm
template1 | pgdbadm | UTF8 | C | en_US.UTF-8 | =c/pgdbadm +
| | | | | pgdbadm=CTc/pgdbadm
(4 rows)

postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
insert | | {}
pgdbadm | Superuser, Create role, Create DB, Replication | {}
select | | {}

Bottom line is that I want this "select" user to be able to query all tables yet to be created in the DB without having to issue grant statments after table craation. But just select, no more.

Thanks in Advance !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message daniel 2012-12-05 03:31:35 ts_headline and query with hyphen
Previous Message Kenneth Tilton 2012-12-05 01:36:31 Re: How get column-wise table info from an arbitrary query?