Attain 3.60 security filter

rivo

I am using Attain 3.60 w. MS SQL server and want to use security filter for No Series. I need use filter like *_|*_TR, this syntax is working with normal table filter but it does not work with security filter. Is it possible to use * symbol in security filter syntax?

Rivo Lemmik

Scott_Frappier

That should work without any problems (if it works within the standard filters). One thing to take note:
"It is important to remember that not applying a security filter to a table means that the user can, for example, read all the entries in that table."

Check to see if there are any other roles that the user utilizes that allow it to read the No. Series table with no Security Filter designated.

Hope this helps!

dmccrae

Wildcards are NOT supported in security filters. Security filters are a subset of regular filters.