Skip to Content

[Univers design tool] derived table and access restriction

Apr 21, 2017 at 03:43 PM


avatar image
Former Member


Before anything else, my version is 4.1 Support Pack 7 Patch 5.

I would like manage an access restriction on the generated sql by a derived table.

I use a prompt in my derived table.

I have 3 acces restriction : R1, R2, R3
name of my derived table : TABLE_XXXX

In the select of TABLE_XXXX : select * from DB_BO.dbo.TABLE_DE_SUIVI_2017_R1

Acces retriction is add in "Manage acces restriction" : DB_BO.dbo.TABLE_DE_SUIVI_2017_R1 -> DB_BO.dbo.TABLE_DE_SUIVI_2017_R2 to R2 group.

The sql genrated by WEBI when i have a R2 restiction :

select * from DB_BO.dbo.TABLE_DE_SUIVI_2017_R1

The restriction don't work whith the derived table but work with normal table.

Is it possible to apply an access restriction on the sql of a derived table?

Thank you for your help.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers