Role Authority when running pgadmin3
От | Jerrold \"Eric\" Thompson |
---|---|
Тема | Role Authority when running pgadmin3 |
Дата | |
Msg-id | 4F09FE79.7020404@whidbey.com обсуждение исходный текст |
Ответы |
Re: Role Authority when running pgadmin3
|
Список | pgadmin-support |
I am new to pgadmin3 and PostgreSQL. I have set the system user 'jet' to be a superuser. I have a database user 'videoworks', and a database videoworks. When I start pgadmin3 from bash and logged in as 'jet', most of the configuration tools are available to me on the videoworks database, except Tools => Server Configuration. At this point: Login Createdb Inherits ...are set to yes Superuser Create Roles Update catalogs are set to no ...........for user videoworks User 'jet' is set to yes for everything. If I set the database user 'videoworks' as a superuser, then restart the server, and restart pgadmin3 I am able to use Tool => System Configuration My question is: I thought it was a bad Idea to grant Superuser status to all roles, but without doing so how am I able to use the TOOL => System Configuration when I start pgadmin3 and I am logged in to the shell as 'jet'? Here is my pg_hba.conf at this point: # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres ident local all jet ident # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 Thank you, Jet
В списке pgadmin-support по дате отправления: