Allowing Access to different grps

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi,

Is it possible for me to allow 4 different groups of
people to have different control in the database?
I combined two different applications into a single
database so now i have 4 groups of ppl. The two different
groups can only read, edit and modify their own
application, and not the other group's application. The
3rd group is able to read,edit and modify ALL the
information in BOTH applications while the last group is
only allowed to READ ALL information from BOTH
applications.

How should i go about doing this??
Can someone kindly help me on this?
Thanks!!!!
 
All of this can be done using so-called "user-level security" (ULS). With
ULS, you can say what users or groups of users have which level of access
(read, edit, add, delete) to each object in the database.

Unfortunately, ULS is quite difficult to understand initially. Get a copy of
the "Access Security FAQ", and plan to spend *at least a few weeks* to get a
basic understanding of it. Read the FAQ many times. Follow its instrctions
*precisely*, adding & omitting nothing. Experiment on some throw-away
databases, before you event think of trying to secure your real database.
Keep a copy of your unsecured database, just in case it all goes wrong & you
lock yourself out!

HTH,
TC
 
Back
Top