Table level Security

[infomania]

I was wondering if my DBA set up access security to deny read access to a table for some users, would they be able to run (refresh) a report created by a user that had read access to the tables? I am using CR 9, accessing data on a SQL Server 2000 database.

Infomania

 

[vidru]

I don't think so. Not unless the reports use login information with SELECT rights to those tables.

-dave

 

[infomania]

Thanks... restating you response.

Users who do not have SELECT rights to a table cannot refresh a report that was created by a user who has SELECT rights to the table. Is this correct?

 

[vidru]

Yes, that is correct. They'll get errors ("Failed to open a rowset" from CR, and "User does not have SELECT permission on table TableName").

However, if the reports are being called from within an application, and the login information that the application uses to connect to the database has SELECT rights, then ALL users would be able to view all reports.

-dave

 

[IdoMillet]

Also, be sure you don't save data with the report...

Chjeers,
- Ido

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

http://www.MilletSoftware.com