Prevent user group from importing tables

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

Guest

Is there a way to give Users the ability to add new records to the database,
but at the same time prevent them from taking any copies of the tables from
it, by importing into other databases???

Thanks in advance.
 
meyerryang said:
Is there a way to give Users the ability to add new records to the
database,
but at the same time prevent them from taking any copies of the tables
from
it, by importing into other databases???

Thanks in advance.
Click to expand...

You need to apply user level security. See my web site for a link to the
FAQ. Be warned it is a complex topic and do make regular backups in case
you lock yourself out.

Keith.
www.keithwilby.com
 
User Level Security is already applied, however due to the design I have
simplified the users to a generic "Users Group". Is it possible to assign
the Users Group the ability to read, update, and insert while preventing a
database from pulling tables out of it?

Thanks.
 
Okay, I determined a workeable way is to set the run permissions properties
of each query as "Owner" and disable all tables permissions. How do I work
around setting the run permissions for a sql based query, such as a UNION
query for example? Is it possible?

Thanks in advance.
 
If you open any of your current RWOP queries, you can use View, SQL View to see the SQL statement. You'll see that the end of the SQL statement has
WITH OWNERACCESS OPTION;

You'd do the same with your UNION query.
 
Yep, I see that. Thank you so much.

Joan Wild said:
If you open any of your current RWOP queries, you can use View, SQL View to see the SQL statement. You'll see that the end of the SQL statement has
WITH OWNERACCESS OPTION;

You'd do the same with your UNION query.
Click to expand...
 
Back
Top