Row Level Security Filters in Framework Manager

[teelee]

Hello All,
I'm trying to set-up 'Row Level Security Filters' in Framework Manager, which allows each person to see only information pertinent to them.

How can I accomplish this? Would that be setting security for each individual person?  Is there any documentation available to show how this is done?

I'm not able to get my data security filters to work for some reason.

Thanks in advance for any and all assistance offered!
teelee

[twlarsen]

Hey Teelee,

The different solutions were given in your previous posting

http://www.cognoise.com/community/index.php/topic,9172.0.html

Theres a few different ways to approach it.  Did you have a question on a certain approach?  It really depends on how you have security defined in your company, but there iare multiple ways.

[teelee]

Hello Twlarsen,
Thanks, yes, I'm trying to use the CSVIdentityNameList Macro Function, to set row level security.  However, I'm missing something because I'm not getting the results I should.
It says, 'The macro function optionally accepts a list separator as a parameter and then returns a separator-delimited list that can be used in a filter with the In operator. You do not need a parameter map'..  That's what I want.

This is what I'm doing:
I Specify Data Security, add my groups, then Create/Edit Embedded filter.

I select Location/Location.Locale, and add this:
Location.LocationLocale='#CSVIdentityNameList()#'  or
Location.LocationLocale.Principal ='#CSVIdentityNameList()#'

doesn't look right to me.

I know this is not correct, but can you tell me what I'm doing wrong?  What should I add between ()?

Thank you for any assistance offered.
Thanks and have a wonderful day!
teelee

[scull]

Hi Teelee,

your problem is that you have '=' there and CSVIdentifyNameList returns a list of values, so = is not valid in this case. You have to use 'contains' or 'in' or smth simmilar, depending where exactly you're placing this thing and what you want it to do.

In any case, be carefull with those macro functions- they are quite buggy if you want to squeeze more than basic functionality out of them.

M
numberstoinfo.blogspot.com