Copy table permissions to new database?

microsoft.public.access.security

5 Sep 2007 2:32 PM

Neil Morris

i have user-level security and multiple groups in my database. I generate
tables in an admin copy of the database and then copy tables to the version
of the database that users access. When tables are copied into the new
database they all get the permissions set for each group of users (set by new
tables/queries permissions), however, I want differing permissions for some
tables for a single group of users.
Traditionally, I have manually altered the permissions for the tables
concerned, but I have now got an admin user to update the database and it is
not working well.

Can I set permissions for each table from the admin version of the database
so that when they are copied into the user version of the database they keep
the permissions I have set?

Thanks