Row Level Security

How will you provide security?
How will you provide row level security?

Questions by gsreddy.789

Showing Answers 1 - 6 of 6 Answers

liladd

  • Oct 5th, 2009
 

You can use session parameters to map a data item to one of the ldap user values.
depending on what you authentication source is and if the necessary values are there.

EX: Your ldap has employee #, your data has a table with employee #, manager#, other columns and this table is joined to you model. You need to do this to all query subject that you want to secure, you map a FM query item to the session parameter employeenumber (from your ldap source). This will filter on the users employee number.
Now to go one step further let's say you have employee and managers as users, if your ldap source has them in different groups you can create a different mapping to equate the employee number of the managers to the manager# query item, this will allow the managers to see all of their staff.

Hope this helps

Liladd

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions