Re: regarding grant option

On Wed, Mar 01, 2006 at 09:50:24AM +0530, AKHILESH GUPTA wrote:
> just tell me the procedure that how can i grant all permissions for a
> database to any of the other user???
> i am using :-
> :->> grant all privileges on database <db_name> to <user_name>;
> GRANT
> :->> grant all ON DATABASE <db_name> to <user_name>;
> GRANT
>
> and the query executes succesfully.
> but at the other user end, she is not able to access the database given in
> the above query.

Can the user connect to the database at all? Is she getting an
error message? If so, what's the error and at what point in the
connection is she getting it? What did she do immediately prior
to getting the error? Do the server logs contain any error messages?
If so, what are they?

If the user can't even connect then the problem is likely with
pg_hba.conf. See "Client Authentication" in the documentation for
more information:

http://www.postgresql.org/docs/8.0/interactive/client-authentication.html

--
Michael Fuhr