Re: Granting permissions

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: "Ashish Karalkar *EXTERN*" <ashish_postgre(at)yahoo(dot)co(dot)in>, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Granting permissions
Date: 2007-04-05 12:00:27
Message-ID: AFCCBB403D7E7A4581E48F20AF3E5DB2020DDD30@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message joachim.sommer 2007-04-05 12:03:23 One database serveral schemas and group roles
Previous Message Alvaro Herrera 2007-04-05 11:57:34 Re: All objects of a Particular USER