This is a multi-part message in MIME format.
------=_NextPart_000_002B_01BFB6B4.D94353E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello, all.
We are working on setting up row level security for our web application.
Our method involves the creation of a view which has in it only those =
rows to which the currently logged on user should have access. This =
table is then joined into all queries, and by virtue of the inner join =
the user only gets to see the appropriate rows from the database.
My question is, are any of you all doing this kind of row level =
security, and if so, do you have other schemes for ensuring that each =
user only sees the rows they should see?
Thanks.
Brian Cusack
------=_NextPart_000_002B_01BFB6B4.D94353E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hello, all.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>We are working on setting up row level security for =
our web=20
application.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Our method involves the creation of a view which has =
in it=20
only those rows to which the currently logged on user should have =
access. =20
This table is then joined into all queries, and by virtue of the inner =
join the=20
user only gets to see the appropriate rows from the =
database.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>My question is, are any of you all doing this kind =
of row=20
level security, and if so, do you have other schemes for ensuring that =
each user=20
only sees the rows they should see?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thanks.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Brian Cusack<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_002B_01BFB6B4.D94353E0--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
