>   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]

Reply via email to