Report Problem (reports background engine)

[ching]

Hi....

I have a probelm with 'reports background engine', I have 2 reports and each report have a role, but the role contain the same granted.

For example :
report1 have role1,
create role role1
grant select on m_table1 to role1;
grant select on m_table2 to role1;

report2 have role2,
create role role2
grant select on m_table1 to role2;
grant select on m_table2 to role2;

I set the role1 is active and role2 is not active, so it just can run the report1, but when I run the report1 then I closed the report1 but reports background engine still actived and then I tried run report2, the report can run well. It should been could not open this report becouse the role was not actived. I know it caused by reports background engine was still actived, becouse when the reports background engine was closed the report2 could not run.

So this a problem with security, I don't know what to do.
Can anybody help me, please! I will very appreciate.

Sorry my English a little bad. I have tried to explain clearly.

Thanks in advance

[miritika]

hello ching,

one imp. thing about roles is that they r always granted to a user and acc. to ur query i guess both the roles have been granted to the same user so in such a case report2 will also run fine.

so what u should do is after the creation of the roles grant them to 2 diff users and then run ur report u will surely see the difference.

hope this helps u. do let me know.

[ching]

Yes you are right, these roles grant to the same user. and I have tried if the roles grant to diff user, the report2 could not run.

But I want the roles grant to the same user, are u have any idea for this?

Thanks