| From: | Randall Perry <rgp(at)systame(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Ulrich Meis <kenobi(at)halifax(dot)rwth-aachen(dot)de>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How do I grant access to entire database at |
| Date: | 2004-07-18 19:52:41 |
| Message-ID: | BD204D49.7DA1B%rgp@systame.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
This is a pain. Couldn't we gave something simple like
GRANT ALL ON database.* TO JOE;
Which would grant full access to all objects in the database to JOE for all
time?
> Ulrich Meis wrote:
>> 1. Write a script that queries the postgres internal tables for all
>> tables,schemas,sequences,views,functions,... and then executes grant
>> statements for each one of them. This would have to repeated each
>> time a new object is created.
>
> Yes, that's the most popular method so far. You could also write a
> stored procedure.
>
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Design/Development
WebObjects Hosting
Mac Consulting/Sales
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dario V. Fassi | 2004-07-18 20:01:08 | Re: ADMIN Migrate postgres databases from SQL_ASCII to UNICODE |
| Previous Message | Dario V. Fassi | 2004-07-18 19:47:20 | Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |