Disable importing

P

Pietro

Hi all,
How can i disable my database users from importing its tables to another
database ?
I'm really very worried about this matter as users can see very
confidentyial data.
 
R

Rick Brandt

Pietro said:
Hi all,
How can i disable my database users from importing its tables to
another database ?
I'm really very worried about this matter as users can see very
confidentyial data.
Click to expand...

If you need to protect your data from non-users of your application use network
security to keep everyone else out of the file.

If you need to protect your data from USERS of your application then it does not
belong in an MDB file. The User Level Security that is available on MDB files
(not the newer AccDB file) is the highest level of protection you can put on
data in an MDB file and that can be hacked by anyone who knows how to use Google
and is willing to spend a few dollars.

For real security you need a server database like SQL Server. Any file-based
system is quite easily broken into.
 
J

John W. Vinson

Hi all,
How can i disable my database users from importing its tables to another
database ?
I'm really very worried about this matter as users can see very
confidentyial data.
Click to expand...

If users can see it, they can...

Write it on a legal pad.
Photograph it.
Take a screenshot and transmit it.
Printscreen.

You can put up some barriers to make it harder for legitimate users to
illegitimately use the data, but there is no technical solution to PREVENT an
authorized user from taking information. That's what the database is for - to
let users see ("take" into their minds) information.

When I worked in a corporate job, I was on the fringes of probably the worst
security breach experienced by the division. A high-level executive asked our
office for copies of some sensitive protocols in his research area. The
request seemed a bit odd, but it was his department and he had every right to
the information. The next week he resigned and went to California to start up
a new competing company...


John W. Vinson [MVP]
 
M

Minton M

Hi all,
How can i disable my database users from importing its tables to another
database ?
I'm really very worried about this matter as users can see very
confidentyial data.
Click to expand...

Fundamentally, you can't. You can confuse yourself and your users with
Access security, but any tech savvy user will get through this. You
can try to hide the backend using a hidden share (put $ in the name),
but again this is security through obscurity and isn't very robust.
The good news is that SQL Server Express is now free and has much
better security, and I strongly recommend you use this (or another
enterprise system) if your data is confidential.
 
P

Pietro

Thank you all for your reply...
I just want to let you know something,at work i'm trying to import the
objects of my database,but i cannot do this unless i unhide the objects...
but the same databse can be imported from my home computer,so i though that
there may be settings that i don't know...
 
R

Rick Brandt

Pietro said:
Thank you all for your reply...
I just want to let you know something,at work i'm trying to import the
objects of my database,but i cannot do this unless i unhide the
objects... but the same databse can be imported from my home
computer,so i though that there may be settings that i don't know...
Click to expand...


If you turn on "show hidden objects" then you can import hidden objects.
 
Top