Re: GRANT all to a super user

On Wed, May 27, 2009 at 9:19 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com>wrote:

> 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
>

There is a '-s' option for createuser that designates the user account as a
superuser.

You can use 'alter user' or 'alter role' to give superuser authority to an
existing account:

alter user [account name] with superuser;

I think the superuser role applies to all databases.

Andrew