DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2001



    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

  2. #2
    Join Date
    Apr 2001

    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.

  3. #3
    Join Date
    Apr 2001
    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?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.