Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

regarding grant option

Поиск
Список
Период
Сортировка
От AKHILESH GUPTA
Тема regarding grant option
Дата
Msg-id ad39daf90602282020q7a65b072l20a119788dbe2db7@mail.gmail.com
обсуждение исходный текст
Ответы Re: regarding grant option
Re: [SQL] regarding grant option
Список pgsql-general
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"

В списке pgsql-general по дате отправления: