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"