From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Question about permissions on database. |
Date: | 2012-09-22 20:35:00 |
Message-ID: | 3a839498829c33e3d14cfa5a328d4312@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Kelly | 2012-09-22 20:47:00 | Re: Question about permissions on database. |
Previous Message | tuanhoanganh | 2012-09-22 11:47:10 | Re: PL/pgSQL debugger and PostgreSQL 9.2 |