Re: a few questions regarding MySQL rights
At 10:21 AM -0400 9/13/03, [EMAIL PROTECTED] wrote: In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: 1) can I create groups, add users and assign privileges to the group? Yup. ??? How do you create a group in MySQL? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a few questions regarding MySQL rights
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: > 1) can I create groups, add users and assign privileges to the group? Yup. > 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? For starters, I'd recommend always using SSH (whether VPNing or not) to encrypt the pipe (puTTY.exe is a great, free Windows-based terminal emulator for that, or Cygwin). It also depends on how your users are connecting (VPNers and other) and are you planning on using ODBC? If so, check out the net on redirecting ODBC requests through SSH. That way the pipe is encrypted, so whether the data is or not is less (but still) important. The config is something like this: ssh -L 80:192.168.0.254:80 -l root -T 192.168.0.254 (You'll need the root password to the DB machine in this case) Check out: http://archives.postgresql.org/pgsql-odbc/2001-09/msg00040.php for more info. How will you be maintaining the DB? Through scripts? If so, SSH and ban Telnet. If you plan to use a GUI, you might check out www.ems-hitech.com/mymanager which provides a method for using SSL (its about $135.00 US). HTH, Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a few questions regarding MySQL rights
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]
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 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, CNSDirector/Sr Systems ConsultantMMT Networks Pty Ltdhttp://www.mmtnetworks.com.au";>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]