Best practice to grant all privileges on all bjects in database?

From: "Joe Kramer" <cckramer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Best practice to grant all privileges on all bjects in database?
Date: 2006-05-19 12:19:55
Message-ID: b4c00a110605190519i3137cf94jb6006062ad2ed3e5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2006-05-19 12:23:35 Re: Contributing code
Previous Message Robert Treat 2006-05-19 12:11:44 Re: RES: Add column and specify the column position in