> can i grant a user to access two database in mySQL?
Yes just use multiple...
GRANT PRIVILEGES ON (or database you want to grant) TO user@"%" IDENTIFIED
BY 'user_pass'
> does mysql has function DECODE like oracle ?
don't know sorry
> how can i know which table or database that user can access if i am
> admin ?
Just check content of mysql database tables "user" etc.
Than RTFM.
Regards
Vojtech
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
