Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Brian Stenglein]

??I’m just getting starting playing around with Jet Express.  I have it hooked up to our SQL Database and can see all the tables with the Table Builder.  I have SQL permissions to all the tables, so that is understandable, but I was concerned about what other users could see.  I logged in with a test user account that doesn’t have the same level of SQL permissions and I can still see all the SQL tables.  Is there a way to prevent users from seeing certain tables in Jet Express?  If so, how?  Ideally Jet would interface with NAV security but it doesn’t look like it.

Thanks,

——————————
Brian Stenglein
Clow Stamping Company
Merrifield MN
——————————

[Brian Stenglein]

?I figured out that Jet does in fact respect the NAV permissions.  It will let you see the table in table builder if you don’t have permissions, but it won’t let you execute the report.

——————————
Brian Stenglein
Clow Stamping Company
Merrifield MN
——————————
——————————————-