topic Authorization error for infoset based query! in Application Development and Automation Discussions

Authorization error for infoset based query!

Former Member — Wed, 15 Apr 2009 01:32:25 GMT

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,

Re: Authorization error for infoset based query!

former_member700663 — Wed, 15 Apr 2009 03:58:23 GMT

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

Re: Authorization error for infoset based query!

Former Member — Wed, 15 Apr 2009 04:59:36 GMT

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

Re: Authorization error for infoset based query!

former_member700663 — Thu, 16 Apr 2009 08:52:49 GMT

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