Row level Security Issue ,need help urgently

[venkat48]

Hi everyone ,


I am working on implementing the row level security in FM .Since our IT Standards  doesn't allow us to create a parameter map,so I have hardcoded the th secutity for each user class in the following way.


Table
Adminv_Entity_code
Adminv_Entity_Name
First Name
LastName
...
.
.
.
.


Group                                                                              Based on                  Filter
allegheny [Directory>Root user class>Regional-users]                             [siiss].[Adminv_Entity_Name]='allegheny'
Beaver [Directory>Root user class>Regional-users]                                 [siiss].[Adminv_Entity_Name]='Beaver' 




Its not throwing any error,but the security is not implemented.Please kindly suggest me Where I am wrong.

thanks in advance

Venkat





                                               

[Yunus]

That should be all that's required.  You can verify the security being applied by viewing the SQL generated in Report Studio.  It simply applies the filter onto the query.

Also keep in mind if you don't disable custom SQL that any user with Report Studio would be able to bypass the row level security.

[Lynn]

Since our IT Standards  doesn't allow us to create a parameter map,so I have hardcoded the th secutity for each user class in the following way.

I am trying very hard to understand what possible reason there is for establishing a standard that prohibits use of a parameter map but would allow hardcoded rules. Particularly hardcoded rules pertaining to data security!   :o

It seems to me you still need to employ a macro function such as CSVIdentityName in your SQL so the results can be filtered appropriately based on the authenticated user.