Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Imported tables lose security permissions

Status
Not open for further replies.

srast

MIS
Nov 11, 2002
42
US
Hello all;
I have a db with secrity permissions for multi user access. The db sits on a server, and periodically I want to back it up and store it in another location. I first delete all the old tables, and then import all the tables with the data. The one issue is that all security permissions for those tables are lost, and I have to redo them for every user. Is there a way around this?
Thanks.
Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top