Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to give an external user (new login) read access to part of the data model from my Database. The user will copy the data model and content from my Database, and then integrate that into their own database.

Should I give the user a read access to the actual tables, or should I create views for the Tables they need to see? If a View is the way to go, can I put unrelated tables in the same View?

share|improve this question
up vote 2 down vote accepted

In almost ALL cases, YES, use a view. Then you can have multiple joined tables, as may be required, whereto you would not have to give any access

share|improve this answer
I can't join all the tables that need to be accessed, since this includes unrelated tables(no keys to connect them), and I want to avoid making a view for every Table - or should I? – Rafael Cichocki Jun 19 '13 at 15:45
No, you will need 1 view per "result set". If you need multiple result sets from multiple (joined or unjoined) tables / result sets, then you must create a view for each. – RoKa Jun 19 '13 at 16:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.