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/[EMAIL PROTECTED]