News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Security Policy on Dim...

Microsoft Dynamics AX (Archived)

Security Policy on DimensionFinancialTag table

(0) Share

Report

Report

Posted on by CU14050944-0

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

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 292,997 Super User 2025 Season 1 on at

Like (0)

Report

RE: Security Policy on DimensionFinancialTag table

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é

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,997 Super User 2025 Season 1

#2

Martin Dráb 231,831 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans