Re: Fwd: [GENERAL] Question about Privileges

2009-03-13 Thread Andreas Wenk
Jack W schrieb: On Thu, Mar 12, 2009 at 3:45 PM, John R Pierce > wrote: Jack W wrote: I also find that if I only grant privileges on database to dbuser as below, without granting privileges on Schema and table to dbuser, dbuser still

Re: Fwd: [GENERAL] Question about Privileges

2009-03-12 Thread Adrian Klaver
On Thursday 12 March 2009 5:00:39 pm Jack W wrote: > On Thu, Mar 12, 2009 at 3:45 PM, John R Pierce wrote: > > Jack W wrote: > >> I also find that if I only grant privileges on database to dbuser as > >> below, without granting privileges on Schema and table to dbuser, dbuser > >> still can not do

Fwd: [GENERAL] Question about Privileges

2009-03-12 Thread Jack W
On Thu, Mar 12, 2009 at 3:45 PM, John R Pierce wrote: > Jack W wrote: > >> >> I also find that if I only grant privileges on database to dbuser as >> below, without granting privileges on Schema and table to dbuser, dbuser >> still can not do SELECT on the tables. >> mydb=# grant all privileges o

Re: [GENERAL] Question about Privileges

2009-03-12 Thread John R Pierce
Jack W wrote: I also find that if I only grant privileges on database to dbuser as below, without granting privileges on Schema and table to dbuser, dbuser still can not do SELECT on the tables. mydb=# grant all privileges on Database mydb to dbuser; Is there any simple way to grant All priv

[GENERAL] Question about Privileges

2009-03-12 Thread Jack W
Assume that I have the following database: Database:mydb Schema: mydb_schema Tables:mydb_table1 mydb_table2 mydb_table3 I create a role: Create Role dbuser LOGIN; mydb=# grant all privileges on mydb_schema.mydb_table1 to dbuser; mydb=# g