Click to See Complete Forum and Search --> : row security


Paul
01-25-2001, 01:21 PM
I have issue with defining row security within a sql7 database. ASP front
end being utilized by many areas.
Thought about groups...Any other suggestions. Looking for possibilites within
db format not necessarily programaticaly.
Thanks

Michael Howard
01-25-2001, 04:03 PM
wanna explain your scenario a little more? a common way is simply to use a
column in a row as the 'acl' and use that as part of a query.

a little more info would help out, however!

"Paul" <paul.jenkins@attc.army.mil> wrote:
>
>I have issue with defining row security within a sql7 database. ASP front
>end being utilized by many areas.
>Thought about groups...Any other suggestions. Looking for possibilites within
>db format not necessarily programaticaly.
>Thanks

Michael Howard
01-25-2001, 04:15 PM
wanna explain your scenario a little more? a common way is simply to use a
column in a row as the 'acl' and use that as part of a query. there are other
tricks including using views.

a little more info would help out, however!

"Paul" <paul.jenkins@attc.army.mil> wrote:
>
>I have issue with defining row security within a sql7 database. ASP front
>end being utilized by many areas.
>Thought about groups...Any other suggestions. Looking for possibilites within
>db format not necessarily programaticaly.
>Thanks