MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Kevin Struckhoff Date:June 14 2005 5:48pm
Subject:RE: [SPAM] - discuss: user management - Bayesian Filter detected spam
View as plain text  
Although my experience with MySQL user management is limited to just
maintaining a handful of users, I find it rather overly-complex because
of the need to maintain a table of users and 'from where' they can have
access, and to what databases they can have access to. For example, I
just installed MySQL Administrator on my laptop and then I had to add
rows allowing me to access MySQL from my laptop. The ODBC connection
setup should suffice. For every instance of MySQL, you have to have an
entry in the user table for every user from every access point. Then
multiply that by the number of databases in each instance and you can
see that administration of the users can get out of hand. 
If I had to choose between the 3 methods listed below, I would choose #2
if there was a large number of roles and users. I would definitely stay
away from option #3 no matter what. HTH.
Kevin Struckhoff 
Customer Analytics Mgr.
NewRoads West
Office 818.253.3819 Fax 818.834.8843
-----Original Message-----
From: Danny Stolle [mailto:d.stolle@stripped] 
Sent: Tuesday, June 14, 2005 10:08 AM
To: mysql@stripped
Subject: [SPAM] - discuss: user management - Bayesian Filter detected
i would like to discuss 'user management' in mysql. Working with Oracle 
you can assign users to roles giving them privileges provided by that 
role. MySql doesn't have Roles. I have read (Managing and Using MySql, 
O'Reilly) 3 options on managing users having multiple roles in a MySql 
1. Giving the user a Single user ID and assign the privileges to that 
user ID
2. Create role-bases users and have different people share the same user

ID for a given role.
3. Create multiple user IDs for each role played by each user 
(dannys_arch as an architect, dannys_dev as a developer).
Which of these 3 options is the most preferable one or are there more 
options which you can use. What are the advantages and disadvantages on 
working with one of these 3 options? how do you handle hostnames when 
working with random ip-addresses on your site.
Or just plain simple (or stupid) what are your experiences on user 
management in a MySql environment.
Best regards,
Danny Stolle
MySQL General Mailing List
For list archives:
To unsubscribe:

RE: [SPAM] - discuss: user management - Bayesian Filter detected spamKevin Struckhoff14 Jun
  • Re: discuss: user managementDanny Stolle14 Jun
RE: discuss: user managementKevin Struckhoff14 Jun
  • Re: discuss: user managementDanny Stolle14 Jun