need a suggestion on Exposing the Data to Customers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » need a suggestion on Exposing the Data to...

need a suggestion on Exposing the Data to Customers

Rate Topic

Display Mode

Topic Options

Author

Message

Mac1986

Posted Tuesday, January 22, 2013 11:56 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:07 AM
Points: 180, Visits: 516

Hi All,
I joined a new team and need a suggestion on exposing data to downstream customers.
I have 5 SQL Instance on different Clusters which has 13 databases that are exposed to users. All databases are CDC Enabled and users have CDC_Admin access and they pull through CT Tables. My question here is

1) Will user's select statements have any negative effects while our CT Tables are getting populated with 2 records for every record in base table?

2) How else can I expose these data to users. I do not want them directly attaching my warehouse SQL Instances. Like if I can get few options I can think about the feasible ones for me.

Post #1410361

« Prev Topic | Next Topic »

Permissions