N
Nydia
I want to create a database for a department that has 4-5
different groups (ex. substance abuse department, Drug
Abuse group, alchol abuse group, etc.)
I would like to use 1 database for all groups, but the
alchol group shouldn't be able to see the drug abuse group
information. Is there a way to put a security, so that
when a person enters there password, it will show only
their group information?
Also, we work with several databases, if I put a security
on this database, will it have any affect on the other
databases that are used? I don't want it to prompt of a
password on any other database..
any help is greatly appreciated
different groups (ex. substance abuse department, Drug
Abuse group, alchol abuse group, etc.)
I would like to use 1 database for all groups, but the
alchol group shouldn't be able to see the drug abuse group
information. Is there a way to put a security, so that
when a person enters there password, it will show only
their group information?
Also, we work with several databases, if I put a security
on this database, will it have any affect on the other
databases that are used? I don't want it to prompt of a
password on any other database..
any help is greatly appreciated