GRANT all to a super user - Mailing list pgsql-general

From Gauthier, Dave
Subject GRANT all to a super user
Date
Msg-id 482E80323A35A54498B8B70FF2B87980040AEFF544@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: GRANT all to a super user  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: GRANT all to a super user  (Andrew Gould <andrewlylegould@gmail.com>)
List pgsql-general

What is the (is there a) grant command that I can use to create a super user without having to specify all the DB objects? 

 

grant all on database foo to thesuper;

and

grant all privileges on database foo to thesuper;

 

Don’t work.

 

I know I can achieve what I want by submitting a grant for each and every object in the DB.  But is there a way to do it all with one command, maybe something like...

 

“grant all privileges on everything to thesuper”  ?

 

Thanks

-dave

pgsql-general by date:

Previous
From: Iv Ray
Date:
Subject: Re: a strange error, resolved
Next
From: Merlin Moncure
Date:
Subject: Re: How to Install Postgres 8.3 in Solaris 10 as a service