Account privileges, access to different tables

[mmigneco]

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

[Vaughan]

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.