Report Problem (reports background engine)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Report Problem (reports background engine)

  1. #1
    Join Date
    Apr 2001
    Location
    indonesia
    Posts
    52

    Question

    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
    ching

  2. #2
    Join Date
    Apr 2001
    Posts
    51

    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
    Location
    indonesia
    Posts
    52
    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
    ching

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