Question about permissions on database.
От | Condor |
---|---|
Тема | Question about permissions on database. |
Дата | |
Msg-id | 3a839498829c33e3d14cfa5a328d4312@stz-bg.com обсуждение исходный текст |
Ответы |
Re: Question about permissions on database.
Re: Question about permissions on database. Re: Question about permissions on database. |
Список | pgsql-general |
Hello, I wanna ask: is there a short way to giver permission to one user to select/insert (all privileges) on whole database ? Im create a user and try to give him all permission on existing database, but when I try to select always got: ERROR: permission denied for relation table_name I simple do: GRANT ALL PRIVILEGES ON DATABASE my_db TO my_user; and when I do that my idea and what Im trying to do is to give all privileges on for select, insert, update ... using sequences, exec functions to one user, but when I try to select, I receive error message: ERROR: permission denied for relation table_name I look at documentation and remained less scarred about how many grants I should do for tables, for sequences, execution. Im using postgresql 9.2 C.
В списке pgsql-general по дате отправления: