As far as I know, MySQL Access Privilege system does not allow you to create groups of users. You can have only users.
Communication between MySQL Server and MySQL client is, normally, NOT encrypted. You can do that using SSL connections to your server (Mysql4 feature). Check http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Secure_connections Sincerily, Leonardo Rodrigues ----- Original Message ----- From: "Jon Miller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 13, 2003 9:53 AM Subject: a few questions regarding MySQL rights Our programmer is designing a large scale database and I have some questions. 1) can I create groups, add users and assign privileges to the group? 2) since this system is going over a VPN the data should be encrypt using 3DES. If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data? 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 ---------------------------------------------------------------------------- ---- > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]