Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SecurityResourcePrivil...
Finance | Project Operations, Human Resources, ...
Suggested answer

SecurityResourcePrivilegePermissions Table is not visible in AOT, but in SQL

(1) ShareShare
ReportReport
Posted on by Rabia Rizwana 64
Hi,

I have a question. Why is the "SecurityResourcePrivilegePermissions" table not visible in the AOT (Application Object Tree) but its visible in SQL database? What is the reason for this, and how can I make this table visible in the AOT?

could someone help me in this?


Thanks & regards,
Rabiarizwana
Categories:
Dynamics 365 Finance
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,462 Super User 2024 Season 2 on at
    SecurityResourcePrivilegePermissions Table is not visible in AOT, but in SQL
    Hi Rabiarizwana,
     
    As mentioned by Martin, some tables are managed in the SQL database only. This is for security and consistency reasons. There are dlls available that can interact with the security model between the user interface and the SQL tables. 
    E.g. the form SysSecRelatedObjects has an option to copy information into temporary tables. You can check the X++ coding how this is being achieved.
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,551 Most Valuable Professional on at
    SecurityResourcePrivilegePermissions Table is not visible in AOT, but in SQL.
    There are quite a few kernel tables that aren't intended for direct consumption by X++ developers and aren't exposed in AOT at all. There is nothing you can do about it; you could only ask Microsoft to change the design. 

    (Moved from Integration, Dataverse, and general topics forum.)

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,462 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,551 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans