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
-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
: 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 understand you correctly I would then encrypt all information
-
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 actually meant was
restricted access.
If I understand you
, whatever) to manage the
user/group system.
HTH
Peter
-Original Message-
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
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 the
and 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
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 been use views when they become availble
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 your
'
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
access to
the groups table and could easily se which password was allocated to each
group
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 access to
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 Ladenfors
Cc: Mysql (E-mail)
Subject: Re: Row level security requirements, can I still use MySQL?
Hi
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
13 matches
Mail list logo