RE: user privileges question

2003-06-26 Thread csebe
> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 1:26 AM > To: michael young; [EMAIL PROTECTED] > Subject: Re: user privileges question > > > At 18:02 -0400 6/25/03, michael young wrote: > >Hi, > >

Re: user privileges question

2003-06-25 Thread Nils Valentin
Hi Paul, 2003年 6月 26日 木曜日 09:55、Paul DuBois さんは書きました: > At 9:19 +0900 6/26/03, Nils Valentin wrote: > >Hi Michael, > > > >you raised an interesting question. > > > >I created a new account (testroot) I gave him all privileges - except the > >GRANT privilege. > > > >GRANT ALL ON *.* TO 'testroot'@'

Re: user privileges question

2003-06-25 Thread Paul DuBois
At 9:19 +0900 6/26/03, Nils Valentin wrote: Hi Michael, you raised an interesting question. I created a new account (testroot) I gave him all privileges - except the GRANT privilege. GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx'; mysql> show grants for testroot; +---

Re: user privileges question

2003-06-25 Thread Nils Valentin
Hi Michael, you raised an interesting question. I created a new account (testroot) I gave him all privileges - except the GRANT privilege. GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx'; mysql> show grants for testroot; +-

Re: user privileges question

2003-06-25 Thread Paul DuBois
At 18:02 -0400 6/25/03, michael young wrote: Hi, I am creating a small web based program for users to access the data in the datbases. New databases will be added in later. I want to create a user to access these databases with certain rights, not all rights. Will I have to grant this user