Securing hidden tables

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hello,

I have an app that is secured, and I'd like to hide some
of the tables. Most, though not all, of these tables I'd
like some user groups to use. My question is, should I
first secure the application and then change the tables'
attribute to hidden? Is there some other way to change
permissions on secured tables? And while I'm at it, is
there any other implication to hiding tables that I
should consider? Thanks in advance to anyone who replies.
 
Hi Barry,
Users should NEVER have access to the base tables.
IF you want them to browse some of the tables, you should
set those tables up in a form using datasheet view.
At a minimum, the database container should be
hidden on startup(Tools...startup) so that they cannot see
the various objects such as tables or queries unless you
intentionally display them in forms.

The Easy Day
 
Back
Top