Re: Granting permissions

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