thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!

On 3/1/06, Alvaro Herrera < [EMAIL PROTECTED]> 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"

Reply via email to