|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 10th, 2008, 06:24 AM
|
|||
|
|||
|
Client Access to Your SQL Db for Reporting??
Can anyone recommend a strategy for sharing SQL Server data with a client? We do not want to give them access through enterprise manager but we do want them to be able to use their own report writing tools to access our data.
Preferably we would like to restrict them to their own database, if possible and read only rights for specific tables and views. If possible we don't want them to see anything else. If you can provide steps, that would be most helpful. Thanks
|
|
#2
July 10th, 2008, 08:11 AM
|
||||||
|
||||||
|
No tables, only views. Set the views to not be updateable, and create them as part of a different schema (not dbo). Then you can give access to just that schema and all is good.
__________________
Primary Forums: .Net Development, MS-SQL, C Programming VB.Net: It's not your father's Visual Basic. [Moving to ASP.Net] | [.Net Dos and Don't for VB6 Programmers]
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Client Access to Your SQL Db for Reporting?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
