Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

sql permissions to virtual tables

(0) ShareShare
ReportReport
Posted on by 7

How can I give sql permissions to virtual tables. Example Event Subscription (2000000140). This is required since the permissions of the database are being adjusted to the developers, and since I don't see the virtual tables I get an error. This happens when uploading a codeunit with production subscribers.

*This post is locked for comments

  • Suggested answer
    Suresh Kulla Profile Picture
    47,791 on at
    RE: sql permissions to virtual tables

    The standard permission set D365 BASIC has all those required permissions, you need to assign that basic permission set to the user.

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

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
EH-09052238-0 Profile Picture

EH-09052238-0 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 1

Featured topics

Product updates

Dynamics 365 release plans