web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

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é

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

Martin Dráb 4 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans