Skip to Content
0
Former Member
Jan 04, 2009 at 05:51 PM

Analysis Authorizations : Query executes but Authorization denied to view

105 Views

This was my objective. I need to make analysis authorizations which will restrict Users in viewing transaction data associated with specific company codes. User A can ONLY access data belong to company code XXXX and user B for company code YYYY.

I started to make analysis authorizations and include these in a role.

Step1 : I activated Company code attribute as authorization relevant. Company code now appears in the list of attributes in Rsecadmin. Then I gave AB99 for company code value. I also gave full authorization to all special characters for company code dimension.

Step2 : I attached analysis authorization to a role using Object: S_RS_AUTH at field:BIAUTH and this role to attached to the testing user.

Step3: When i test this user with a test query containing company code transactions, the query executes and but does not display the transaction data. A message displays : You do not have sufficient authorization.

Following information is available in the error log

-


Following Set Is Checked Comparison with Following Authorized Set Result Remaining Set

Characteristic Content(in SQL Format)

0TCAACTVT

0COMP_CODE

0TCAACTVT = '03'

AND 0COMP_CODE LIKE *

Characteristic Content(in SQL Format)

0COMP_CODE I EQ AB99

0TCAACTVT I CP *

Partially or Fully Authorized (Intersection) Characteristic Content(in SQL Format)

0TCAACTVT

0COMP_CODE

NOT 0COMP_CODE = 'AB99'

AND 0TCAACTVT = '03'

-


Following Set Is Checked Comparison with Following Authorized Set Result Remaining Set

Characteristic Content(in SQL Format)

0TCAACTVT

0COMP_CODE

NOT 0COMP_CODE = 'AB99'

AND 0TCAACTVT = '03'

Characteristic Content(in SQL Format)

0COMP_CODE I EQ AB99

0TCAACTVT I CP *

Not Authorized

All Authorizations Tested

-


Can anyone please advise, am I missing anything here.

Srinivas