thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!
On 3/1/06, Alvaro Herrera < alvherre@commandprompt.com> wrote:AKHILESH GUPTA wrote:
> 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.
Yes. If you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)
"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"