Grant Question

Поиск
Список
Период
Сортировка
От Travis Whitton
Тема Grant Question
Дата
Msg-id slrnbc045f.42h.whitton@grub.ath.cx
обсуждение исходный текст
Ответы Re: Grant Question  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-admin
Hi - I'm new to postgreSQL, and I'm having some issues with using GRANT.
I'm looking for a way to grant privileges on all tables in a given database
to a user. I can accomplish this using individual grant statements for each
table; however, a global grant is not working for me. Here's an example.

template1=# CREATE DATABASE dummy;
CREATE DATABASE

edit=# \c dummy;
You are now connected to database dummy.

dummy=# CREATE TABLE test (id int);
CREATE TABLE

dummy=# CREATE TABLE test2 (id int);
CREATE TABLE

dummy=# GRANT ALL ON DATABASE dummy TO devel;
GRANT

dummy=# \dp
Access privileges for database "dummy"
Schema | Table | Access privileges
--------+-------+-------------------
 public | test  |
 public | test2 |
(2 rows)

No privileges...

dummy=# GRANT ALL ON test TO devel;
GRANT

dummy=# \dp
Access privileges for database "dummy"
Schema | Table |         Access privileges
--------+-------+------------------------------------
 public | test  | {=,postgres=arwdRxt,devel=arwdRxt}
 public | test2 |
(2 rows)

This works but only by referencing a specific table. Any
help would be appreciated.

Thanks,
Travis Whitton <whitton@atlantic.net>

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

Предыдущее
От: "Jason Kosowan"
Дата:
Сообщение: Problem upgrading PGSQL7.3.2 from PGSQL6.5 under RHLinux6.5 - missing global/pg_control
Следующее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: problems with moving a database