how to allow a sysid to be a superuser?

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема how to allow a sysid to be a superuser?
Дата
Msg-id 482E80323A35A54498B8B70FF2B87980042458DD76@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: how to allow a sysid to be a superuser?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general

Hi:

 

PG 8.3.4 on Linux.

 

A DB was created with a privileged account which has limited access.  I want a specific user (sysuid) to have “all” provs on this DB.  In fact, I want this user to have “all”  on all the dbs served by the PG instance.  Is there a way to do this such that when psql is invoked in a session of that user, he/she automatically has “all” (wothoug havng to enter “-user theuid”)?

 

Thanks

-dave

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

Предыдущее
От: Julian Mehnle
Дата:
Сообщение: regexp_matches() quantified-capturing-parentheses oddity
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Question on "best practise" for SELECTS on inherited tables