Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Thanks Albe , yes,database means all objects of that database. I will check this out. Thanks Ashish... Albe Laurenz <[EMAIL PROTECTED]> wrote: > I want to give only select,insert,update,delete permission on > a particular database to a user. and aslso this user should > not have any cr

Re: [GENERAL] Granting permissions

2007-04-05 Thread Albe Laurenz
> I want to give only select,insert,update,delete permission on > a particular database to a user. and aslso this user should > not have any createdb permission. I think that you get the concept wrong. You cannot select from a database, you can only select from a table (or view). You probably

Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Even More is there any way to grant permission to a user on another database ?? With Regards Ashish "A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 04.04.2007, um 22:23:20 -0700 mailte Postgres User folgendes: > Is there a way to grant INSERT and UPDATE permissions on all the > ta

Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Hi, I want to give only select,insert,update,delete permission on a particular database to a user. and aslso this user should not have any createdb permission. With Regards Ashish... "A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Thu, dem 05.04.2007, um 7:59:11 +0100 mailte Ashish Karalkar

Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Hi, I want to give only select,insert,update,delete permission on a particular database to a user. and aslso this user should not have any createdb permission. With Regards Ashish... "A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Thu, dem 05.04.2007, um 7:59:11 +0100 mailte Ashish Karalkar

Re: [GENERAL] Granting permissions

2007-04-05 Thread A. Kretschmer
am Thu, dem 05.04.2007, um 7:59:11 +0100 mailte Ashish Karalkar folgendes: > > Even More is there any way to grant permission to a user on another database > ?? What do you want to do? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-

Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Even More is there any way to grant permission to a user on another database ?? With Regards Ashish "A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 04.04.2007, um 22:23:20 -0700 mailte Postgres User folgendes: > Is there a way to grant INSERT and UPDATE permissions on all the > ta

Re: [GENERAL] Granting permissions

2007-04-05 Thread Ashish Karalkar
Even More is there any way to grant permission to a user on another database ?? With Regards Ashish "A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 04.04.2007, um 22:23:20 -0700 mailte Postgres User folgendes: > Is there a way to grant INSERT and UPDATE permissions on all the > ta

[GENERAL] Granting permissions

2007-04-04 Thread Postgres User
Is there a way to grant INSERT and UPDATE permissions on all the tables in a database? I don't want to type-in every table name... ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Granting permissions

2007-04-04 Thread A. Kretschmer
am Wed, dem 04.04.2007, um 22:23:20 -0700 mailte Postgres User folgendes: > Is there a way to grant INSERT and UPDATE permissions on all the > tables in a database? I don't want to type-in every table name... http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.htm