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

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема how do I grant select to one user for all tables in a DB?
Дата
Msg-id 0AD01C53605506449BA127FB8B99E5E13E11699D@FMSMSX105.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: how do I grant select to one user for all tables in a DB?
Re: how do I grant select to one user for all tables in a DB?
Список 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 !

В списке pgsql-general по дате отправления:

Предыдущее
От: Kenneth Tilton
Дата:
Сообщение: Re: How get column-wise table info from an arbitrary query?
Следующее
От: daniel
Дата:
Сообщение: ts_headline and query with hyphen