> 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
