Skip to Content
0

[Univers design tool] derived table and access restriction

Apr 21, 2017 at 03:43 PM

76

avatar image
Former Member

Hi,

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
TABLE_DERIVE_XXXX.OBJET
FROM
(
select * from DB_BO.dbo.TABLE_DE_SUIVI_2017_R1
) TABLE_DERIVE_XXXX

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.

Antoine

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

0 Answers