Prevent user group from importing tables

[meyerryang]

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.

 

[Keith Wilby]

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.

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

 

[meyerryang]

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.

 

[meyerryang]

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.

 

[Joan Wild]

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.

 

[meyerryang]

Yep, I see that. Thank you so much.

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.