Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Restrict the particula...
Finance | Project Operations, Human Resources, ...
Suggested answer

Restrict the particular tables in SQL Server via creating username and password !

(0) ShareShare
ReportReport
Posted on by vinilkumar 318

Hi Friends, I have one challenge on SQL side.

We have tables 'vendtable, custtable, generalJournalentry, generalJournalAccountEntry'  in AX, but due to Integration I need to give access on these tables.

My client don't want to 'share sysadmin access'. what he is asking I need to give access and share the username and Password on these tables.

My solution is, in sql server we have 2 options

1.) authentication (no restriction)

2.) create username and password, so that while opening SSMS need to connect via Username and password.

client want to ask second option i.e create a username and password (show only the above tables, means restrict these tables) and share this username and password to the client.

Can we give access for particular tables (example custtable, vendtable, journaltableentry etc..) in SQL (by creating username and password) ?

is it possible to share the above, if yes, please help me.

Regards,

vinilkumar.

  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at
    RE: Restrict the particular tables in SQL Server via creating username and password !

    Hi Vinilkumar,

    Table level permission can be granted in SQL. Link shared by Martin is useful for this.  Create a separate user for this is a better idea.

    If possible to have write access for integrated system with AX, you can write Batch job in AX and push the data in integrated system.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 233,019 Most Valuable Professional on at
    RE: Restrict the particular tables in SQL Server via creating username and password !

    First of all, creating a user name and password isn't your only option. You can also use Windows Authentication.

    Of course that settings permissions in SQL Server is possible. For example, look at Grant table-level permissions in SQL Server.

    Nevertheless directly accessing the DB is considered a bad practice. You must open access to the DB, you bypass security in AX, you can't reuse any business logic defined in AX (including table relations) so on. It still may be the best solutiin in some cases, but you should think carefully before resorting to it.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,277 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans