From: | "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | regarding grant option |
Date: | 2006-03-01 04:20:24 |
Message-ID: | ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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"
From | Date | Subject | |
---|---|---|---|
Next Message | Noel Faux | 2006-03-01 05:12:53 | Data corruption zero a file - help!! |
Previous Message | Greg Sabino Mullane | 2006-03-01 04:07:13 | Re: majordomo unmaintained, postmaster emails ignored? |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-03-01 05:19:57 | Re: regarding grant option |
Previous Message | Michael Glaesemann | 2006-03-01 03:05:58 | Re: pg reserved words |