Skip to Content
0

Row level security causing scheduling prompt timeout

May 22, 2017 at 03:41 PM

83

avatar image
Former Member

I recently added a row level restriction using 'Manage Access Restrictions' from the universe design tool. The restriction is applied to one user group only and works fine. i.e. query results are being restricted as expected.

The problem is that when users from this group now try to schedule a Webi report, the prompts never show up! After several minutes of waiting the connection times out. I've verified that this problem is happening after implementation of the row level security restriction, and when the row level restriction is removed the prompts show up with no delay. This row level security is absolutely necessary from a confidentiality perspective in our organization.

Universe Design Tool 4.1 BI Platform 4.1 Support Pack 6 Version: 14.1.6.1702

Please Help!

Ahmed

10 |10000 characters needed characters left characters exceeded

Hi,

Does the prompts work when they run WEbI report within Bi Launchpad?.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

Hi Jothi,

If you mean being able to refresh data providers from within the Webi document, then yes. They can see the prompts, select the values and run the report.

The prompt issue is only coming up when attempting to schedule any of the reports built with prompts.

Thanks,

Ahmed

0

Does the prompts created within Universe are assigned to this User Group within Security Editor?.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

Yes, I have another access level which is a copy of the access level for the user group having the prompt issue; the only difference between the two is that one has the row level security applied and the other does not.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jyothirmayee A May 23, 2017 at 02:29 PM
0

Hi,

Are the user trying to enter the prompts that you have restricted to?.

Hope they have scheduling rights.

What happens when you do it with a test id?.

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

No, the prompts are not related to the rows that are being restricted but it is quite possible that the queries contain objects that have to be evaluated by the restriction. If that is causing the delay then that defeats the purpose of creating a row level restriction :(

Yes they have scheduling rights because I've tested by using the 'Run Now' option on an existing instance and it works.

Thanks,

Ahmed

0
Manikandan Elumalai May 23, 2017 at 03:46 PM
0

Does your restriction set also includes object level security? Can you provide more details like how your restriction set being configured?

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

The restriction does not include object level security only row level. I've attached screenshots.

The restriction is configured for a specific user group so that group if not able to see data related to a specific site. Since that site information that needs to be restricted is on two tables, two where clauses have been added.

2017-05-23-14-09-09.gif

Thank you,

Ahmed

0

Are we testing with users who is having exclusive membership with usergroup having restriction?

0
Former Member

Yes, besides being a member of the Everyone group in CMC.

0