http://pgedit.com/tip/postgresql/access_control_functions
On 5/19/06, Joe Kramer <cckramer@xxxxxxxxx> wrote:
Hello,
I need to grant all privileges on all objects in database. Without
using SUPERUSER.
It's strange that GRANT ALL PRIVILEGES ON DATABASE is useless, it
don't grant privileges on tables.
I've found out this "best practice", (more like ugly workaround):
select 'grant all on '||schemaname||'.'||tablename||' to
\\\"$USER\\\";' from pg_tables where schemaname in ('public');
select 'grant all on '||schemaname||'.'||viewname||' to
\\\"$USER\\\";' from pg_views where schemaname in ('public');
and same for functions,sequences etc.
Is there nicer, more friendly way? Maybe there is something like
contrib module or procedure that does that in user-friendly way?
If not, anyone has a better version of above grant script?
