• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

Link DB

Hi,

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
0
mcrmg
Asked:
mcrmg
  • 4
  • 3
1 Solution
 
SireesCommented:
<<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.
0
 
mcrmgAuthor Commented:
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
0
 
SireesCommented:
<<a VIEW that links to pdn db>>

Do they need all the tables or just few of them?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mcrmgAuthor Commented:
they need all of them ...thx
0
 
SireesCommented:
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..
0
 
mcrmgAuthor Commented:
if I can only let me them use VIEW, they can not see the structure, right?
0
 
mcrmgAuthor Commented:
Is VIEW faster then the query?  thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now