Re: Add Restricted User

2007-09-27 Thread Robby Tanner
I had not explicitly granted any privileges. Is that just the required default assignment of some kind? Regards, Rob ""Robby Tanner"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I want to add a user who can login from anywhere but has restricted privileg

Add Restricted User

2007-09-27 Thread Robby Tanner
I want to add a user who can login from anywhere but has restricted privileges on a single DB. I tried: GRANT SELECT, INSERT, UPDATE ONcaddb.* TO 'autocad'@'%' IDENTIFIED BY 'password'; The query ran and the user was entered with the proper privileges, however, when I tried to setup an ODBC

RE: Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner
z [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 17, 2003 4:10 PM > To: Robby Tanner > Cc: [EMAIL PROTECTED] > Subject: Re: Inserting '#' char as part of a field > > > Robby, > > > How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # > > sign?

Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner
g', 'F:\\else\\bl#\\');" How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # sign? Add extra quotes or a backslash before the character? Use double quotes? Some other method? ZeosDBO is a set of components for talking to MySQL via the LibMySQL.dll. Regards, Robby