Prevent Exportation of Objects

[Anne]

Is there a way to prevent tables from being exported to
another database?

I have a security concern - a person's own personal
information should be accessed by them but they should not
be able to access anyone else's. This is accomplished via
the front end and is totally locked down to prevent anyone
getting into the tables to view the data of others.

However, there's nothing to prevent someone from creating
a new database and importing all of the tables into it.

Thanks in advance for any suggestions.

 

[Chris Nebinger]

You need to implement tougher security, using the Security
FAQ available at MSDN:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;165009

You need to strip all rights away from the tables, and
then grant access to special queries that only pull the
current users privacy data.

If this isn't secure enough, consider using SQL Server or
Oracle to better tighten the screws.


Chris Nebinger