Grant blanket permissions on a database
От | Kirk Strauser |
---|---|
Тема | Grant blanket permissions on a database |
Дата | |
Msg-id | 87snaq92i8.fsf@legion.priv обсуждение исходный текст |
Ответы |
Re: Grant blanket permissions on a database
Re: Grant blanket permissions on a database |
Список | pgsql-general |
I am using PostgreSQL-7.1.2_2 on a FreeBSD 4.4-STABLE server. I am running Apache on the same machine, and have a PHP website that connects to the PostgreSQL server on localhost. I want the user that the website connects as to have full permission to do anything it wants on that particular database, so it seemed like it would be reasonable to add to my pg_hba.conf: host mydatabase 127.0.0.1 255.255.255.255 crypt This works, in general. However, I always get errors similar to: Warning: PostgreSQL query failed: ERROR: sysusers_usersys_seq.nextval: you don't have permissions to set sequence sysusers_usersys_seq when trying to insert data into a table with a serial field. Shouldn't the host line allow that user full permission to create, drop, and update every element in the database? -- Kirk Strauser Internet Software Engineer NMotion, Inc.
В списке pgsql-general по дате отправления: