Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
donjt81
Starting Member
11 Posts |
 Posted - 2012-02-16 : 12:11:06
|
| There is an external tool (external to our group but still within the same company) that needs to access some data that is within one of my tables. When I say access, I mean they only need to read the data. They dont have to update any of my tables.I am trying to figure out the best way to handle this.The first thing that comes to mind is, I can create a view with the desired data, create a new user name and password and grant that user name "select" permissions. Then that external tool can use SQL server authentication with the user name and password I just created and read the data.Is this the best way to handle this type of scenario? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
donjt81
Starting Member
11 Posts |
Posted - 2012-02-16 : 13:22:52
|
| Whats with the ? at the end. Are you not sure about your answer? or maybe that was sarcasm |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Best way to provide data to external tools