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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / 2009 Database Permissi...
Microsoft Dynamics NAV (Archived)

2009 Database Permission Issue

(0) ShareShare
ReportReport
Posted on by Jaideep Sengupta 430

To All Experts,

I have a situation in my hand in NAV 2009 R2 where a new user has been created and added to the active directory but not created as a windows user or database user in the database. Still the user is able login into the database and make changes, entries as he may seem fit.

Can anybody tell me the reason how the user can access the database without even creating a user in the NAV database.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,358 Super User 2025 Season 2 on at
    RE: 2009 Database Permission Issue

    HI Jaideep,

    Are there any users in database or there is no user in the database?

    If there are no users in the database then anyone can access and process transaction in the database.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at
    RE: 2009 Database Permission Issue

    Agreed with Saurav. Dynamics NAV will only allow the users to login without a account if there are no users available in the user setup table in Dynamics NAV. Check the users are created inside NAV.

  • Jaideep Sengupta Profile Picture
    Jaideep Sengupta 430 on at
    RE: 2009 Database Permission Issue

    Hi Saurav,

    Users are there in the database i.e. in the users, windows login as well as user setup table but as I said this particular is not present.

    Is it possible that the Windows Server permission somehow supersedes the NAV permission.

  • Jaideep Sengupta Profile Picture
    Jaideep Sengupta 430 on at
    RE: 2009 Database Permission Issue

    Hi Tharanga,

    I agree with both of you. This is something I am facing the first too.

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,671 on at
    RE: 2009 Database Permission Issue

    Is the user in question setup as a Domain Admin? If so then they may have full access to the SQL Server. Or is the user in question setup as a SQL Admin? Same result.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans