Skip to Content
0
Former Member
Oct 28, 2014 at 04:05 PM

Security profile in Universe using IDT

28 Views

Hi,

I was thinking about if is it possible to give dinamic permissions.

Imagine that we have the table: Users with the column: Department. That table is relationated with all the Universe. If i want every user have permission in order to their departmen i can create a profile in the WHERE clause like: Department ='2'.

The question is, if i have 200 users from 200 different departments, if i can to create a variable in order to take the department of the user who just connect to the universe, something like: Department=var_dep

Sorry for my english and sorry if my question is not for this forum.

Thank you.