Re: [HACKERS] grants

2004-03-10 Thread Kris Jurka
On Wed, 10 Mar 2004, Andreas Pflug wrote: > Kris Jurka wrote: > > >On Wed, 10 Mar 2004, Andreas Pflug wrote: > > > >The problem that cannot be solved with either this or a function that > >loops and grants on each table is that it is not a permanent grant of what > >the admin had in mind. If

Re: [HACKERS] grants

2004-03-10 Thread Andreas Pflug
Kris Jurka wrote: On Wed, 10 Mar 2004, Andreas Pflug wrote: Edgar Mares wrote: hi there i'm having troubles to find how to GRANT SELECT ON all-tables-onmydb TO specificuser this is just to give the access to "specificuser" to query the database and find troubles on it

Re: [HACKERS] grants

2004-03-10 Thread Kris Jurka
On Wed, 10 Mar 2004, Andreas Pflug wrote: > Edgar Mares wrote: > > > hi there i'm having troubles to find how to > > GRANT SELECT ON all-tables-onmydb TO specificuser > > > > this is just to give the access to "specificuser" to query the > > database and find troubles on it > > pg

Re: [HACKERS] grants

2004-03-10 Thread Andreas Pflug
Edgar Mares wrote: hi there i'm having troubles to find how to GRANT SELECT ON all-tables-onmydb TO specificuser this is just to give the access to "specificuser" to query the database and find troubles on it pgAdmin II has a tool for that (Security wizard; pgAdmin III has it on the

Re: [HACKERS] grants

2004-03-09 Thread Christopher Kings-Lynne
hi there i'm having troubles to find how to GRANT SELECT ON all-tables-onmydb TO specificuser There isn't any such command. You need to write a stored procedure to do it for you in a loop. Chris ---(end of broadcast)--- TIP 1: subscribe and u

[HACKERS] grants

2004-03-09 Thread Edgar Mares
hi there i'm having troubles to find how to GRANT SELECT ON all-tables-onmydb TO specificuser this is just to give the access to "specificuser" to query the database and find troubles on it thnx for your time ---(end of broadcast)