regarding grant option

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"

Responses

Browse pgsql-general by date

  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?

Browse pgsql-sql by date

  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