From: AKHILESH GUPTA <akhilesh.davim@gmail.com>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: regarding grant option
Date: Wed, 1 Mar 2006 09:50:24 +0530
Message-ID: <ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com> (raw)
hi all....
this is akhilesh from india.i just want to ask one thing regarding grant
operation??
i am using pgsql 8.0 on ubuntu 5.10 linux.
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.
here i have to grant permissions to that user individually for each and
every table by using:
:->> grant ALL ON <tab_name> to <user_name>;
GRANT
and all the permissions are granted to that user for that particular table.
i want same results for the entire database.................
plz help me it's urgent
--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)
"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
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: akhilesh.davim@gmail.com, pgsql-general@postgresql.org
Subject: Re: regarding grant option
In-Reply-To: <ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com>
* 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