Showing posts with label accessing. Show all posts
Showing posts with label accessing. Show all posts

Wednesday, March 21, 2012

How to loop thru' Fields in Report

I'm using Reporting Server 2005. I have published my report as Web service. Now I'm accessing the Web Service (Report) from my C# code. Here I would like to loop all the fields available in the report. How to do this?

Thanks in Advance.

Regards,

vnisor.

Have you considered using one of the data renderers (such as XML)? When you render it will only return the data in the report and not any formatting. It should make it much easier to extract the data you are interested in programmatically.

Monday, March 19, 2012

How to Lock out DBA from Salary tables

Is there a way to lock out DBAs from accessing certain tables e.g. Salary ta
bles.
If so what permissions need to be set?Peter,
No! The SysAdmin account is GOD! There is no way to prevent a SysAdmin
account from doing anything it wants with any of the tables or databases.
If you have sensitive information, then you should consider encrypting the
information using some mechanism unknown to your DBA.
Chief Tenaya
"Peter" <peter@.offtomexico.com> wrote in message
news:F58B95B8-640B-45B7-A90C-BCFDA4FBDA3E@.microsoft.com...
> Is there a way to lock out DBAs from accessing certain tables e.g. Salary
tables.
> If so what permissions need to be set?|||A DBO yes. If your DBA is a member of the Sysadmins group, then the answer
is no.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.