Link DB

Posted on 2006-11-30
Last Modified: 2006-12-01

I would like to create a new DB, no tables, for now, I will just create a VIEW and that VIEW will connect to our PDN DB, is this doable?  My boss want to have one of our biz person to look at the data, but he does not want to show the pdn db...thx
Question by:mcrmg
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 20

Expert Comment

ID: 18045300
<<to look at the data, but he does not want to show the pdn db>>

If he needs to look at only a couple of tables, you can export them to Excel.

If you need to give him read access to all the tables you can give him db_datareader for that database.

Author Comment

ID: 18045353
We are trying out this software that can link to sql and create reports, but my boss does not want them to link to PDN and see all the structure, so, I want to see if it is possible that they can connect to a dummy db that has a VIEW that links to pdn db...thx
LVL 20

Expert Comment

ID: 18045375
<<a VIEW that links to pdn db>>

Do they need all the tables or just few of them?
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.


Author Comment

ID: 18045405
they need all of them ...thx
LVL 20

Accepted Solution

Sirees earned 100 total points
ID: 18045476
I don't see how you can allow them to see all the data and not the structure.

One thing you could do is, to create a new db and export just the tables to that database and given them access..

Author Comment

ID: 18046089
if I can only let me them use VIEW, they can not see the structure, right?

Author Comment

ID: 18051251
Is VIEW faster then the query?  thx

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question