Home > Default > What if I implement data level security using Selection formula?

What if I implement data level security using Selection formula?

November 30Hits:0
Advertisement
Hi All,
I have a requirement to implement data level security for all the reports, the thing is, we donot have a front end application developed in java/.net or any other language, so we have only two options (as per me, if you think there are other alternatives then please share).
1) Implement security at the database level (that is use user roles in where clause which will make the where clause really complicated and hence the performance of the query will eventually decrease).
2) Retrieve the data with the flags of user role/permission on data. Use these flags in selection formula to select the needed records as per the user login.
I have already in middle of implementing the second method, thought to take suggestion from you guys, I appreciate if you could tell me the drawbacks of the method I am using, and if there is an alternative method you could think of.
Thanks,
-Azhar

Answers

Standaone Crystal Reports does not have any security option except to use Trusted Authentication when connecting to the DB. We use Microsofts NT or MS SQL Server Authentication only.
Doing this in CR Designer using flags and formula will never be secure, the user could simply change the formula etc...
Check with your DBA on how to configure AD authentication and then enable or add each user to SQL server. You may need to configure and mantain this manually depending on how you ahve your network configured.
Thank you
Don

Read other 5 answers

Tags:

Related Articles

  • What if I implement data level security using Selection formula?November 30

    Hi All, I have a requirement to implement data level security for all the reports, the thing is, we donot have a front end application developed in java/.net or any other language, so we have only two options (as per me, if you think there are other

  • How to implement data level securityNovember 30

    How to implement data level security in BI Publihser?. I am using Obiee enterprise edition and bi publihser. My requirement is to show data based on User- Region relation ship. User A - belongs to Eastern Region User B - belongs to Southern Region so

  • Implementing Data level Security ?November 30

    I would like to Impelement Data level Security in Universe level itself. I have Set For users belonging to Branch (Mumbai, Delhi Etc) And One set of Users Belonging to Segment (CWG, IFA Etc) and  Set of users that are combination oif Branch and Segme

  • Data level Security issue in obiee 11gOctober 11

    Hi, We are trying to implement data level security, let me explain the issue The requirement is, we have 7 schools and each school has one principle , there will be a Superdintent who has 3 schools under him. so now when each principle logs in to das

  • Data level Security in EssbaseOctober 11

    I have an requirement to implement data level security in Essbase. For ex: A user can only see those data which are from Asia region or an user will be able to see those data which are from America. Asia and America are defined in my location dimensi

  • Data level security in OBIEEOctober 11

    We have implemented data level security by applying filters on groups in Obiee Administration tool. Here we have set filter on division(which is a column in Customer table). This is done so that user can see data for division for which he has access.

  • Data level Security for Oracle Apps as SourceNovember 30

    Hi all I need to implement Data level Security on Apps Users in OBIA We are using Apps as source with Single sign On. I need to apply Data level security on Business Group Field. We dont have users in OBI, we need to register apps users in OBI. Could

  • Data level Security with Oracle Apps as SourceNovember 30

    Hi all I am implementing Data level Security with Apps as Source(OLTP) on Single Sign On.(Oracle has provided the Vanila rpd & we are working on that) I need to Filter data based on Business Group, Users are created in Apps and they are registered wi

  • Data level SecurityNovember 30

    I need to implement data level security on the dashboards for users based on job hierarchy and region location since i have multiple subject areas this needs to be implemented on one subject area and reports and dashbord from the same subject area .

  • Data level security for 30000 profir centersNovember 30

    Hello Gurus I have a requirement to implement data level security for 30000 profit center . Now I can think of creating the groups and applying security filters ( both on Dimesion & Fact) on the top of that. But I cannot do so as I will have to creat

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.605 s.