web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Security Policy on DimensionFinancialTag table

(0) ShareShare
ReportReport
Posted on by

Hi

im trying to set up a security police on  on "DimensionFinancialTag" table.

In SQL the result would / should Display something like

select * from Dimensionfinacialtag where (description  like '%XXX%'  and financialcategorytag in ( 1,2,3) ) or financialcategorytag = 4

Did follow :

https://technet.microsoft.com/en-us/library/hh272121.aspx

and manage to get the results for :

select * from Dimensionfinacialtag where (description  like '%XXX%' )

but how can i add the additional criterias?

The idea of this is:

Users are allowed to see some values for some financialdimensions and for one Dimension all values

Any hints?

Thanks

Pirmin

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    306,335 Super User 2026 Season 1 on at

    Hi Pirmin,

    Are you aware of the next whitepaper? www.microsoft.com/.../details.aspx

    This describes something, but not fully your requirement.

    Can you explain in detail what you had done so far?

    kind regards,

    André

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans