Re: [GENERAL] GRANT all to a super user

2009-06-01 Thread Jasen Betts
On 2009-05-27, Gauthier, Dave wrote: > --_000_482E80323A35A54498B8B70FF2B87980040AEFF544azsmsx504amrc_ > Content-Type: text/plain; charset="us-ascii" > Content-Transfer-Encoding: quoted-printable > > What is the (is there a) grant command that I can use to create a super use= > r without having to

Re: [GENERAL] GRANT all to a super user

2009-05-27 Thread Andrew Gould
On Wed, May 27, 2009 at 9:19 AM, Gauthier, Dave 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

Re: [GENERAL] GRANT all to a super user

2009-05-27 Thread Pavel Stehule
Hello there are not similar statement if you would to grant rights to more database objects, you have to use script or stored procedure. regards Pavel Stehule 2009/5/27 Gauthier, Dave : > What is the (is there a) grant command that I can use to create a super user > without having to specify al

[GENERAL] GRANT all to a super user

2009-05-27 Thread Gauthier, Dave
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