Re: revoke question

2004-03-17 Thread doug
REVOKE ALL PRIVILEGES FROM [EMAIL PROTECTED] seems to be a 4.1 form of the command (I have 4.0.15) but adding '@localhost' did the trick. Thank you. On Wed, 17 Mar 2004, Michael Stassen wrote: > > [EMAIL PROTECTED] wrote: > > > I was trying to allocate a new user and I typed something like: > > >

Re: revoke question

2004-03-16 Thread Michael Stassen
[EMAIL PROTECTED] wrote: I was trying to allocate a new user and I typed something like: grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill'; Here you grant [EMAIL PROTECTED] all privileges on a table named pail. I realized I made a mistake needing to specify (at least) 'pai

revoke question

2004-03-16 Thread doug
I was trying to allocate a new user and I typed something like: grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill'; I realized I made a mistake needing to specify (at least) 'pail.*', intending to grant the user access to a database I created. So to clean up I tried: revo