Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-10 Thread Peter Eisentraut
Radoslaw Stachowiak writes: > > The problem with this approach is that if you do "revoke all on database > > from all" you have hosed your system. Text files allow recovery in these > > situations. > > thats completly wrong :) look at the whole UNIX dir permissions topic. > Using postgres super

Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-10 Thread Radoslaw Stachowiak
*** Peter Eisentraut <[EMAIL PROTECTED]> [Tuesday, 09.January.2001, 18:50 +0100]: > > This is one of the features of PgSQL that I do not > > like. It is much nicer to type: > > "grant all on database.table to ." > > And I asked the developers to do that but they did not > > take it very seriou

Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-10 Thread R D
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > R D writes: > > > This is one of the features of PgSQL that I do not > > like. It is much nicer to type: > > "grant all on database.table to ." > > And I asked the developers to do that but they did > not > > take it very seriously. > > The

Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-09 Thread Peter Eisentraut
R D writes: > This is one of the features of PgSQL that I do not > like. It is much nicer to type: > "grant all on database.table to ." > And I asked the developers to do that but they did not > take it very seriously. The problem with this approach is that if you do "revoke all on database

Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-08 Thread R D
--- Kevin Schachter <[EMAIL PROTECTED]> wrote: > I recently installed Postgres on my server to rid of > the horrible > limitations of Mysql. However I am having some > trouble setting up > permissions as they are in MySQL. > > In MySQL you can grant a user select permissions to > all tables in a

Re: [ADMIN] Granting Permissions to User To Access Database

2001-01-06 Thread Anthony E . Greene
On Sat, 06 Jan 2001 15:22:46 Kevin Schachter wrote: >In MySQL you can grant a user select permissions to all tables in a >database >with the command "GRANT select on db.* to .". Is there a similar way to >accomplish this in Postgres? Reading up on GRANT I see that it only works >for individual

[ADMIN] Granting Permissions to User To Access Database

2001-01-06 Thread Kevin Schachter
I recently installed Postgres on my server to rid of the horrible limitations of Mysql. However I am having some trouble setting up permissions as they are in MySQL. In MySQL you can grant a user select permissions to all tables in a database with the command "GRANT select on db.* to .". Is t

[ADMIN] Granting Permissions to User To Access Database

2001-01-06 Thread Kevin Schachter
I recently installed Postgres on my server to rid of the horrible limitations of Mysql. However I am having some trouble setting up permissions as they are in MySQL. In MySQL you can grant a user select permissions to all tables in a database with the command "GRANT select on db.* to .". Is t