From: Michael Fuhr <mike@fuhr.org>
To: AKHILESH GUPTA <akhilesh.davim@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: regarding grant option
Date: Tue, 28 Feb 2006 22:19:57 -0700
Message-ID: <20060301051957.GA16661@winnie.fuhr.org> (raw)
In-Reply-To: <ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com>
References: <ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, akhilesh.davim@gmail.com, pgsql-general@postgresql.org
Subject: Re: regarding grant option
In-Reply-To: <20060301051957.GA16661@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox