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 tables

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 tables

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-ID:

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 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 tables

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
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

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...

[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