Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MEM - Possible to apply to SQL Server user?

(0) ShareShare
ReportReport
Posted on by

We have an MEM environment in GP where a user has access to only entities that they are assigned to.

We are looking at another third party application which accesses the SQL server database to populate SOs/Invoices from the SOP10100 table.

The objective is to limit what POs populate based on the entity access that a connection has with its SQL server authentication.

Is it possible to limit the access a SQL server user has based on the MEM setup? I don't mean roles where a user can't access entire modules like sales or purchasing, but entities within each module. 

If it helps the logic behind the MEM setup for SOP10100 is basically the following:

SELECT a.SOPNUMBE,
b.BSSI_Facility_ID

FROM SOP10100 a

INNER JOIN B3930100 b
ON a.SOPNUMBE = b.SOPNUMBE

WHERE b.BSSI_Facility_ID in (SELECT c.BSSI_Facility_ID from B3900200 c WHERE c.USERID = 'userid')

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

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,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans