Re: [GENERAL] Question about permissions on database.

2012-09-22 Thread Condor
On 2012-09-22 23:47, Ryan Kelly wrote: On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote: 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,

Re: [GENERAL] Question about permissions on database.

2012-09-22 Thread Craig Ringer
On 09/23/2012 04:35 AM, Condor wrote: I look at documentation and remained less scarred about how many grants I should do for tables, for sequences, execution. You probably need to read this: http://stackoverflow.com/questions/11599533/postgresql-8-4-grant-dml-privileges-on-all-tables-to-a-rol

Re: [GENERAL] Question about permissions on database.

2012-09-22 Thread Chris Angelico
On Sun, Sep 23, 2012 at 6:47 AM, Ryan Kelly wrote: > On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote: >> 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 permissio

Re: [GENERAL] Question about permissions on database.

2012-09-22 Thread David Johnston
On Sep 22, 2012, at 16:35, Condor wrote: > 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: > ERRO

Re: [GENERAL] Question about permissions on database.

2012-09-22 Thread Ryan Kelly
On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote: > 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

[GENERAL] Question about permissions on database.

2012-09-22 Thread Condor
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 simp