I wish to:
GRANT SELECT ON mediabankmaster.clients TO [EMAIL PROTECTED]
GRANT SELECT,INSERT ON mediabankmaster.publicdocs TO [EMAIL PROTECTED]
however, this does not work.
'cemail' can SELECT from clients.
'cemail' can INSERT into publicdocs.
'cemail' CAN NOT SELECT from publiccocs.
I don't know what causes this.
even when i remove all the grants from 'cemail' and just have the
select on public docs, it still does not allow 'cemail' to select
from the publicdoc table.
as you can see from the output below, I think the GRANTS are right..
why doesn't it work?
mysql> show grants for [EMAIL PROTECTED];
+----------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
| |
+----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'cemail'@'clients.mediabankit.com' IDENTIFIED BY PASSWORD
|'06b8fb4b2db8cc44' |
| GRANT SELECT ON mediabankmaster.publicdocs TO 'cemail'@'clients.mediabankit.com'
| |
+----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
[1]+ Stopped mysql -p (wd: /apache/mediabank/clients/jun)
(wd now: /apache/mediabank/public)
[root@dahmer:public]# fg 2
mysql -u cemail -p -h clients.mediabankit.com
select * from mediabankmaster.publicdocs;
ERROR 1142: select command denied to user: '[EMAIL PROTECTED]' for table
'publicdocs'
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
