Skip to Content
avatar image
Former Member

[Univers design tool] derived table and access restriction

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers