| 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: | Whole Thread | Raw Message | 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 |