Is there a way to move all tables to system, then only move a few back

0 votes

I am trying to make a quick front end for a system that has over 100 tables in the DB. They only need to see 4 of these. Is there a way to move all tables to System and I can then move the 4 back. It is very slow to drag that many tables to System.


in How To by (160 points)

1 Answer

+1 vote
Best answer

There are two different ways to resolve this issue:

  1. Create a database-user for that application (Strongly Recommended), See: Database User
  2. Set the Database Defaults so that new tables show up as System.
by (64.5k points)
selected by
This was a big help.  Thank you.
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer