Search Postgresql Archives

GRANT all to a super user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux