Re: Add Restricted User

OK, scratch that, I was being stupid. I had two ODBC configuration dialogs open and they must have been conflicting.

Another question though, during the ODBC config, I noticed I could pick either the caddb for which the account had access or "information_schema" for which I had not explicitly granted any privileges. Is that just the required default assignment of some kind?

Regards,
Rob

""Robby Tanner"" <robby_tanner@hotmail.com> wrote in message news:20070927194722.25650.qmail@lists.mysql.com...
>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 connection using that account, I
> got an SQL_ERROR.
>
> Then I ran:
>
> GRANT ALL PRIVILEGES ON *.* to 'autocad'@'%';
>
> and I could connect via ODBC. That seems to me as if I've given what
> should be a restricted user waaaay too much access. How can I apply the
> restrictions that I want while still being able to have the user connect?
> Does the account need some global privilege to allow it to connect?
>
> Cheers,
> Rob
>

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com