Securing DB W/O Passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there any way to secure my DB without having my users type in a name and
pw? I seem to find conflicting answers by going through old posts and would
like a definitive answer. We are running '03 by the way.

I'd like to prevent access to the tables after a co-worker showed me she
could mail merged my tables in Word and get access to essentially any data
she wanted. It was quite eye opening.
 
Will this stop the pilferer from mail merging as well then? Thank you for
your assistance.
 
If you secure the database, you can remove all permissions on the tables and
use RWOP queries for all data interaction. They won't be able to do a merge
with the tables then. However they would still be able to merge with any of
the RWOP queries that they have read data permissions on.

I must ask just what harm there is in doing a mail merge. It doesn't allow
them to actually change the data.
 
There is data in a table that we don't want everybody to be able to view such
as emergency contact info.

Could you please explain RWOP query? Sorry for being ignorant to the
abbreviation.
 
Back
Top