granting all to user

Поиск
Список
Период
Сортировка
От Jodi Kanter
Тема granting all to user
Дата
Msg-id 004101c197be$83083c60$de138f80@virginia.edu
обсуждение исходный текст
Ответы Re: granting all to user  ("Nick Fankhauser" <nickf@ontko.com>)
Re: granting all to user  ("Nick Fankhauser" <nickf@ontko.com>)
Re: granting all to user  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-admin
Can I grant a user all privileges to all the tables without having to type a
grant command for each table individually?

I know that I can use:
grant all on object to username

but I would like to set this person up as a superuser for now so that he can
assist with development.

It appears that when I set up users the default is NOT to give them access
to any of the tables. I would like to have the default set so that users can
read all the tables and then have the option to give this one particular
person full access.

Any suggestions???
thanks
Jodi


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: libcrypt problem
Следующее
От: Jodi Kanter
Дата:
Сообщение: unknown index