Re: [GENERAL] Granting permissions
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 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 mean 'select permissions for all tables in a database'. There is no such thing. Permissions are stored on the objects themselves, so a table "knows" who is allowed to access it. For what you want, you must give the user a) permissions on all individual tables he/she should access b) USAGE privilege on the Schemata c) CONNECT privilege to the database. Yours, Laurenz Albe - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
> 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 mean 'select permissions for all tables in a database'. There is no such thing. Permissions are stored on the objects themselves, so a table "knows" who is allowed to access it. For what you want, you must give the user a) permissions on all individual tables he/she should access b) USAGE privilege on the Schemata c) CONNECT privilege to the database. Yours, Laurenz Albe ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Granting permissions
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 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.html#extended Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
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 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: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
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 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: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
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: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Granting permissions
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 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.html#extended Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
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 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.html#extended Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings - Heres a new way to find what you're looking for - Yahoo! Answers
Re: [GENERAL] Granting permissions
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.html#extended Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings