re: creating a user with certain privileges

["Jon Miller" <suppressed>]

In our SQL database we want to create a user with certain privileges. Also we need to only allow them to view certain tables not the entire lot.
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
    ON {tbl_name | * | *.* | db_name.*}
    
Using the above syntax, by granting a person certain privleges does this mean that they can only see the table and database that the privilege is given to?  Also by using username@'%' does this mean the username can login from anywhere.  We need to allow the user to login from a remote location via the Internet.

Thanks


Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au

"I don't know the key to success, but the key to failure
 is trying to please everybody." -Bill Cosby





---------------------------------------------------------------------
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 <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php