Re: discuss: user management: conclusion

2005-06-15 Thread Danny Stolle
Danny Stolle wrote: hi, 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

discuss: user management

2005-06-14 Thread Danny Stolle
hi, 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

RE: [SPAM] - discuss: user management - Bayesian Filter detected spam

2005-06-14 Thread Kevin Struckhoff
Struckhoff Customer Analytics Mgr. NewRoads West Office 818.253.3819 Fax 818.834.8843 [EMAIL PROTECTED] -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 10:08 AM To: mysql@lists.mysql.com Subject: [SPAM] - discuss: user management - Bayesian

Re: discuss: user management

2005-06-14 Thread Danny Stolle
] - discuss: user management - Bayesian Filter detected spam hi, 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

RE: discuss: user management

2005-06-14 Thread Kevin Struckhoff
818.834.8843 [EMAIL PROTECTED] -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 11:12 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: discuss: user management Hi Kevin, yes it is a complex matter, i agree completely. but how would

Re: discuss: user management

2005-06-14 Thread Peter Brawley
as a developer). #2 has a name (role-based user access, RBAC) and is widely used, but its formulation above needs a correction: create roles, and users who can be assigned different and possibly multiple roles. PB - Danny Stolle wrote: hi, i would like to discuss 'user management' in mysql

RE: discuss: user management

2005-06-14 Thread TheRefUmp
and standard role based assignments in mind. I am hopeful that they will correct this issue down the road. Regards, George Danny Stolle [EMAIL PROTECTED] wrote: hi, i would like to discuss 'user management' in mysql. Working with Oracle you can assign users to roles giving them privileges

Re: discuss: user management

2005-06-14 Thread Danny Stolle
. NewRoads West Office 818.253.3819 Fax 818.834.8843 [EMAIL PROTECTED] -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 11:12 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: discuss: user management Hi Kevin, yes it is a complex matter

Re: discuss: user management

2005-06-14 Thread Danny Stolle
. Regards, George Danny Stolle [EMAIL PROTECTED] wrote: hi, 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

Re: discuss: user management

2005-06-14 Thread Danny Stolle
). / #2 has a name (role-based user access, RBAC) and is widely used, but its formulation above needs a correction: create roles, and users who can be assigned different and possibly multiple roles. PB - Danny Stolle wrote: hi, i would like to discuss 'user management' in mysql. Working

Re: discuss: user management

2005-06-14 Thread Scott Gifford
Danny Stolle [EMAIL PROTECTED] writes: [...] 3. Create multiple user IDs for each role played by each user (dannys_arch as an architect, dannys_dev as a developer). An interesting argument in favor of the much maligned option 3 is that it allows users to select which of their privileges they

Re: discuss: user management

2005-06-14 Thread Peter Brawley
multiple roles. PB - Danny Stolle wrote: hi, 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

RE: discuss: user management

2005-06-14 Thread Gordon Bruce
of the data for people reporting to me.} Direct access via SQL would be extremely limited. -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 2:05 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: discuss: user management Hi Kevin, i