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