Copy table permissions to new database?

N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
Removing Admin Permissions from my database 1
ULS Update/Delete Permissions not working 5

Top