Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Account privileges, access to different tables

mmigneco
in Security Concepts

Featured Replies

  • Newbies

Hello everyone.

I'm working with a database that includes 4 different companies, each company have a group of tables, several are related tables between different companies.

I am considering to give access to the different users to each company, in this case I don't want a particular user to be able to enter on some tables. Is there a way to do it?

i could separate the database into smaller ones, one for each company and could re-arrange the relational database to work this way, but if I could manage the user privileges but will be easier.

What do you guys think about it?

Thanks a lot for your help!

Milko Migneco

You can limit access to tables with privilege sets.

However your fundamental data design is not good. The companies should NOT have separate tables. This will become a HUGE maintenance overhead.

There should be ONE table with a COMPANY field in it to determine the company.

Or use separate files for each company.

Create an account or sign in to comment

https://fmforums.com/topic/82126-account-privileges-access-to-different-tables/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.