Database Security

[Chris Wood]

Hi,

I created a database ("First Database") and set up the
security for it, including workgroup, users, groups, and
permissions. I tried to apply this security to another
database ("Second Database") that was created by another
user with a different security setup.

In Second Database, I can join the workgroup for First
Database. However, users, groups, and passwords do not
change. Do I have to manually change this, or is there a
way to pull in the group and user setup from First
Database into Second Database?

Thanks,

Chris Wood

 

[Eric Butts]

Hi,

No there is not. Example:

WorkGroupA WorkGroupB
----------------------- ------------------------
BobA BobB
JohnA JohnB
JaneA JaneB


There's no way to have result of:

WorkGroupA
-----------------------
BobA
JohnA
JaneA
BobB
JohnB
JaneB

Would need to manually add them.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[Douglas J. Steele]

Eric: Glad to see you in the groups, but in the future, could you please
quote at least some of the original questions? Answers only aren't that
useful to others.