Postgres Pro
Downloads
Home   >   mailing lists

Thread: Granting permissions

Granting permissions

From
"Postgres User"
Date:
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...

Re: Granting permissions

From
"A. Kretschmer"
Date:
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

Re: Granting permissions

From
Ashish Karalkar
Date:

Even More is there any way to grant permission to a user on another database ??
 
With Regards
Ashish
"A. Kretschmer" <andreas.kretschmer@schollglas.com> 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

Here’s a new way to find what you're looking for - Yahoo! Answers

Re: Granting permissions

From
Ashish Karalkar
Date:

Even More is there any way to grant permission to a user on another database ??
 
With Regards
Ashish
"A. Kretschmer" <andreas.kretschmer@schollglas.com> 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

Here’s a new way to find what you're looking for - Yahoo! Answers

Re: Granting permissions

From
Ashish Karalkar
Date:

Even More is there any way to grant permission to a user on another database ??
 
With Regards
Ashish
"A. Kretschmer" <andreas.kretschmer@schollglas.com> 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

Here’s a new way to find what you're looking for - Yahoo! Answers

Re: Granting permissions

From
"A. Kretschmer"
Date:
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

Re: Granting permissions

From
Ashish Karalkar
Date:
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" <andreas.kretschmer@schollglas.com> 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

Here’s a new way to find what you're looking for - Yahoo! Answers

Re: Granting permissions

From
Ashish Karalkar
Date:
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" <andreas.kretschmer@schollglas.com> 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

Here’s a new way to find what you're looking for - Yahoo! Answers

Re: Granting permissions

From
"Albe Laurenz"
Date:
> 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

Re: Granting permissions

From
Ashish Karalkar
Date:

Thanks Albe ,
yes,database means all objects of that database.
I will check this out.
Thanks
Ashish...
Albe Laurenz <all@adv.magwien.gv.at> 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

Here’s a new way to find what you're looking for - Yahoo! Answers