A
alex richardson
I maintain an HR reporting database for about 50 users.
The employee records a user is eligible to use vary based
on employee cost center. A given user has access to
employees in a certain set of cost centers. Currenly I
have queries that create separate databases for users with
access to each set of cost centers. A macro runs the
queries to create these databases. These databases are
FTP'd to a website and users see only the database to
which they have access when they sign on to the website.
Is there a more streamlined way of giving multiple users
access to a part of the database?
The employee records a user is eligible to use vary based
on employee cost center. A given user has access to
employees in a certain set of cost centers. Currenly I
have queries that create separate databases for users with
access to each set of cost centers. A macro runs the
queries to create these databases. These databases are
FTP'd to a website and users see only the database to
which they have access when they sign on to the website.
Is there a more streamlined way of giving multiple users
access to a part of the database?