record security / security policy

(0) Share

Report

Posted on by CU14050944-0

i created a security policy to hide mainaccounts no longer used (something in the query like Name !old account .. this works fine as Long as i am in the main accounts from.. but when e.g. selecting an accoun on the invoice Journal and i use the drop down list, i still see the "!old accounts" in the drop down list .. any hints how to solve?

thankx

Pirmin

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 306,773 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Pirmin,

The drop down list is looking at a view, not the main accounts table. You can add the view DimAttributeMainAccount as contrainted table as well. Then your problem should be solved.

Have a look at this whitepaper as well: www.microsoft.com/.../details.aspx.

.

Was this reply helpful? Yes No