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 u

RE: discuss: user management

2005-06-14 Thread Gordon Bruce
should only be able to see my own employee data or some parts 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.my

Re: discuss: user management

2005-06-14 Thread Peter Brawley
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 with Oracle you can assign users to roles giving them privile

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

Re: discuss: user management

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

Re: discuss: user management

2005-06-14 Thread Danny Stolle
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 provided by that role. MySql doesn't have Roles. I have read (Ma

Re: discuss: user management

2005-06-14 Thread Danny Stolle
ber of roles? Kevin 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 11:12 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: d

RE: discuss: user management

2005-06-14 Thread TheRefUmp
th auditing 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 &g

Re: discuss: user management

2005-06-14 Thread Peter Brawley
, dannys_dev 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 '

RE: discuss: user management

2005-06-14 Thread Kevin Struckhoff
18.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, i agree completely

Re: discuss: user management

2005-06-14 Thread Danny Stolle
Subject: [SPAM] - 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

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

2005-06-14 Thread Kevin Struckhoff
H. Kevin 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

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 multi