Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread GH
On Wed, Jan 31, 2001 at 03:39:46PM -0700, some SMTP stream spewed forth: > : El Mié 31 Ene 2001 18:32, Dan Wilson escribió: > : > You can do this in phpPgAdmin... it's a hack because it just pulls in > all > : > the objects/relations and runs a single grant statement on them, but it > : > works.

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Dan Wilson
You can do this in phpPgAdmin... it's a hack because it just pulls in all the objects/relations and runs a single grant statement on them, but it works. It puts together a query like the following: GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO user Which I suppose y

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Dan Wilson
: El Mié 31 Ene 2001 18:32, Dan Wilson escribió: : > You can do this in phpPgAdmin... it's a hack because it just pulls in all : > the objects/relations and runs a single grant statement on them, but it : > works. It puts together a query like the following: : > : > GRANT ALL ON table1, table2, t

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Martin A. Marques
El Mié 31 Ene 2001 18:32, Dan Wilson escribió: > You can do this in phpPgAdmin... it's a hack because it just pulls in all > the objects/relations and runs a single grant statement on them, but it > works. It puts together a query like the following: > > GRANT ALL ON table1, table2, table3, view1

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Martin A. Marques
El Mié 31 Ene 2001 15:53, Michael Fork escribió: > This is the closest thing to what you want: > > GRANT ALL ON table TO user; > > (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm) Yes, I'm aware of that. That's why I'm asking for an opinion of the developers on this issue

[HACKERS] Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Michael Fork
This is the closest thing to what you want: GRANT ALL ON table TO user; (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm) Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Wed, 31 Jan 2001, Martin A. Marques wrote: > El Mar 30 Ene