DML Command in Report

[rjduke]

Hi,

We have some reports in our Intranet. We have granted all users a role to read tables in our Oracle Environment, but it is not their default role.

So, when I logon to the Reports, I need to be able to SET ROLE TRLMREAD so that they can retrieve data for that session.

Any idea how I may execute this command after I logon?

 

[synapsevampire]

What does logon to reports mean? Are you using Crystal Enterprise, or?

Any idea what version of Crystal you're using?

How do the reports connect to the database?

Are you using Tables, Views or Stored Procedures in the reports?

A Stored Procedure might allow for this, otherwise this might be a bit tricky. Or if you're building a rowset within code and passing it to Crystal you should be able to do this as well, which would be consistent with your dbas approach of "hand coding" the connectivity.

Most organizations will use different schemas to accomplish what your dba is doing. If all users are logging in to the same role with the same rights, perhaps you should create a generic user login for reporting purposes. It all sounds whacky to me, giving them rights to everything, but not by default...

-k

 

[rjduke]

Hi,

I'm running CR-v9 on Oracle 8i with IIS.

We need to set a READ Only Role when they login to our Report Intranet. The reason we need each users login is so that they only see sensitive data relevent to their department, which is derived from our security table.

Interestingly you mentioned a subreport with a Stored Procedure... I have a stored procedure

create or replace procedure HD_setrole
as
begin
EXECUTE IMMEDIATE 'SET ROLE TRLMREAD';
end;
/

If the subreport called that... should work?

 

[synapsevampire]

It might, but the SP needs to return data.

I would also think that you'd need to use an SP for any data calls to set the role and log in.

Not sure, I fear that you might need external code, or use the ADD COMMAND to paste in your SET ROLE and the QUERY.

-k