04-15-2009 2:32 AM
Hi all,
I have a question on infoset authorization. Would appreciate if anyone can help me.
Query is defined on infoset,which contains multiple infoset objects for company code and profit centres.
I have created anyslysis autho object which contains profit centre and company code with values.
Now I am getting below error.
All Authorizations Tested
Message EYE007: You do not have sufficient authorization
No Sufficient Authorization for This Subselection (SUBNR)
Following CHANMIDs Are Affected:
380 ( ZCOPA_I01___F48 )
411 ( ZCOPA_I01___F81 )
Here F48 is for company code and F-81 is for profit centre.
it is showing that infoobjects for company code and profit centre are not present in anlysis autho object
even after it is present .
I also implemented SAP NOTES (1234334) and 1292293.
Did anyone encountered this kind error.
Thanks,
RS
04-15-2009 4:58 AM
Hi,
Can you check if this query is hiting any other authorization relevant object for which analysis authorization assignment is not available for the users.
Also can you provide the sql statement log if available in the rsecadmin analysis.
Regards,
Nilanjan
04-15-2009 5:59 AM
Hi Nilanjan,
Thank you for replying , below is trace result.
Authorization Check Log
Date and Execution Time (Local Server)
Execution Date: 04/15/2009
Execution Time: 04:34:48
Executed Query: ZCOPA_I01/QZCOPA_I01_0001
Transaction RSRT ( BW - Output Test )
Executed by User 134054
Executed with Analysis Authorizations of Another User TESTPC01
-
InfoProvider Check
Building the Buffer...
...Buffer Built
Are there authorizations for accessing InfoProvider ZCOPA_I01 with activity 03?
Authorization exists for general access to InfoProvider ZCOPA_I01 with activity 03
-
-
Relevant Characteristics for Detailed Authorization Check
(Characteristics with Full Authorization Are Not Listed!)
List of Effective Authorization-Relevant Characteristics for InfoProvider ZCOPA_I01:
0PROFIT_CTR
ZCOPA_I01___F31
0COMP_CODE
ZCOPA_I01___F48
ZCOPA_I01___F62
ZCOPA_I01___F81
0TCAACTVT
There are authorization-relevant InfoSet characteristics with the following meaning: ISETNAME IOBJNM
ZCOPA_I01___F31 0PROFIT_CTR
ZCOPA_I01___F48 0COMP_CODE
ZCOPA_I01___F62 0COMP_CODE
ZCOPA_I01___F81 0PROFIT_CTR
-
-
Authorization Check
Detail Check for InfoProvider ZCOPA_I01
Preprocessing:
Selection Checked for Consistency, Preprocessed and Supplemented As Needed
Subselection (Technical SUBNR) 1
Check Node Definitions and Value Authorizations...
Node- and Value Authorizations Are OK
End of Preprocessing
-
Filling the Buffer...
...Buffer Filled
Main Check:
-
Subselection (Technical SUBNR) 1
Supplementation of Selection for Aggregated Characteristics
No Check for Aggregation Authorization Required
Following Set Is Checked Comparison with Following Authorized Set Result Remaining Set
Characteristic Content(in SQL Format)
0COMP_CODE
0PROFIT_CTR
0TCAACTVT
0COMP_CODE = '3000'
AND 0TCAACTVT = '03'
AND 0PROFIT_CTR LIKE *
Characteristic Content(in SQL Format)
0COMP_CODE I BT 3000 3999
I EQ :
0PROFIT_CTR Node 1
0TCAACTVT I EQ 03
Not Authorized
All Authorizations Tested
Message EYE007: You do not have sufficient authorization
No Sufficient Authorization for This Subselection (SUBNR)
Following CHANMIDs Are Affected:
380 ( ZCOPA_I01___F48 )
411 ( ZCOPA_I01___F81 )
Authorization Check Complete
-
-
Used Hierarchy Node Definitions: Node Hierarchy:Version:Key Date:Node InfoObject:Node Name:Type:Level:Validity Area:Structure Date
Node 1 2000ADESKPCA : : 99991231 : 0HIER_NODE : 00000000000000000000000020002000 : 1 : 00 : 0 : 00000000
04-16-2009 9:52 AM
Hi Shashidhar,
I think you are using Hierarchy authorization for 0PROFIT_CTR . Can you please check that if everything is fine with the hierarchy authorization. It might be problem with this one. You can also check by providing full access to the hierarchy and see if that works.
Regards,
Nilanjan