Elevated security needed for Crystal Reports on client machines? 1

[EBECK]

We have a Visual Basic database application (the database is SQL Server 2000) that also uses Crystal Reports for reporting. The VB/CR application is installed on the client machines.

A couple of users would like Crystal Reports installed on their machines to create several of their own reports (in addition to the reports within the VB/CR application on their machines). These Crystal Reports would link to the SQL Server database on a server. My question: Would we need (or should we have) elevated security for the Crystal Reports created on their client machines?

Thank you in advance for your time and consideration.

 

[IdoMillet]

I find your message confusing. Please try again. What's the problem? What do you mean by elevated security?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[EBECK]

We are using SQL authentication for different levels of permission for the database. The person creating the Crystal Report doesn't have complete permission to the database.

I hope this helps.

 

[IdoMillet]

That clarifies the situation a bit. So what is the problem?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[EBECK]

Not so much a problem as a question (or two).

If Crystal Reports were installed on a couple of client machines, would these users have access to the database fields they otherwise would not have access to? Would these users be able to create reports under their current permissions?

 

[IdoMillet]

Crystal is not involved in securing your data. The security is something you apply at the database level. If the database requires user id and password, Crystal prompts for it.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com