Re: Row level security requirements, can I still use MySQL?

2004-11-18 Thread mos
At 03:45 AM 11/18/2004, you wrote: Hello, I am in the position where I need row level user access, this is crucial in my current project. I know this has been discussed before and the answer has been "use views when they become availble". But views would still allow the "root" user access to the co

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jonas Ladenfors
arked as excluded from the "global access option". But your suggestion of removing the "root" user would solve my problem but increase administration?. /jonas -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 14:29 To: Jonas Ladenf

Re: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Sergei Golubchik
Hi! On Nov 18, Jonas Ladenfors wrote: > Hello, I am in the position where I need row level user access, this is > crucial in my current project. I know this has been discussed before and the > answer has been "use views when they become availble". But views would still > allow the "root" user acce

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Peter Lovatt
ember 2004 12:36 > To: 'Peter Lovatt' > Subject: RE: Row level security requirements, can I still use MySQL? > > > Ok, This is a nice solution but it still lacks a thing I would like to > avoid. Any user with "global" access for example root would have &g

Re: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jochem van Dieten
On Thu, 18 Nov 2004 13:07:11 +0100, Jonas Ladenfors wrote: > > Anyway I was given a link by Mark Leith (thanks!) on Oracle row level access > that seems interesting. > > Here it is (not MySQL but the "mind-work" might be interesting). > http://www.securityfocus.com/infocus/1743 It does not meet

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jonas Ladenfors
bject: Re: Row level security requirements, can I still use MySQL? On Thu, 18 Nov 2004 10:45:37 +0100, Jonas Ladenfors wrote: > Hello, I am in the position where I need row level user access, this is > crucial in my current project. I know this has been discussed before and the > answer has bee

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jonas Ladenfors
might not be applicable to this solution. Regards /Jonas -Original Message- From: Luke Venediger [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 12:35 To: Jonas Ladenfors Cc: Peter Lovatt; [EMAIL PROTECTED] Subject: Re: Row level security requirements, can I still use MySQL? Hi, I

Re: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jochem van Dieten
On Thu, 18 Nov 2004 10:45:37 +0100, Jonas Ladenfors wrote: > Hello, I am in the position where I need row level user access, this is > crucial in my current project. I know this has been discussed before and the > answer has been "use views when they become availble". But views would still > allow

Re: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Luke Venediger
Is this how other RDBMS enforce access restrictions? > > > > Regards > > /Jonas > > > > -Original Message- > > From: Peter Lovatt [mailto:[EMAIL PROTECTED] > > Sent: den 18 november 2004 11:03 > > To: Jonas Ladenfors; Mysql (E-mail) > >

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jonas Ladenfors
age- > From: Jonas Ladenfors [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 10:19 > To: 'Peter Lovatt'; 'Mysql (E-mail)' > Subject: RE: Row level security requirements, can I still use MySQL? > > > Yeah you are correct locking is something else I actu

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Peter Lovatt
> Sent: 18 November 2004 10:19 > To: 'Peter Lovatt'; 'Mysql (E-mail)' > Subject: RE: Row level security requirements, can I still use MySQL? > > > Yeah you are correct locking is something else I actually meant was > restricted access. > > If I understa

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Jonas Ladenfors
-Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 11:03 To: Jonas Ladenfors; Mysql (E-mail) Subject: RE: Row level security requirements, can I still use MySQL? Hi What about encrypting the data using a password that is specific to the user. That way only

RE: Row level security requirements, can I still use MySQL?

2004-11-18 Thread Peter Lovatt
Hi What about encrypting the data using a password that is specific to the user. That way only those that know the password for that row can access it. Locking is really to stop two users editing the same record at the same time, rather than controlling access. HTH Peter > -Original Mess