Skip to Content
0
Former Member
Dec 01, 2011 at 10:26 AM

Error in Authorization even after giving Colon authoriztion to users

651 Views

Dear Experts

We have built a query which is having Sum GT function used and also Constant for some characterstics.

But when we execute the query the user is getting not authorized message. If i run the query without the SUM GT and Constant RKF and CKF its running fine.

We have checked the rsec log for the error it says Colon authorization is required for the some chars which are authorizaiton relavant but we have given all the other chars : authorization but still i am getting the below message.

Authorization Check Log

For a general description see the Note 1234567

Date and Execution Time (Local Server)

Execution Date: 01.12.2011

Execution Time: 15:33:23

Executed Query: ZM_SD_M22/ZM_SD_M22_Q_00010

Transaction RSRT ( BW - output test )

Executed by User P00010784

Executed with Analysis Authorizations of Another User P00007960

Software Component Release Level Support Package

SAP_ABA 700 0021 SAPKA70021

SAP_BASIS 700 0021 SAPKB70021

SAP_BW 700 0023 SAPKW70023

-


InfoProvider Check

Building the Buffer...

...Buffer Built

Are there authorizations for accessing InfoProvider ZM_SD_M22 with activity 03?

Authorization exists for general access to InfoProvider ZM_SD_M22 with activity 03

-


-


Relevant Characteristics for Detailed Authorization Check

(Characteristics with Full Authorization Are Not Listed!)

List of Effective Authorization-Relevant Characteristics for InfoProvider ZM_SD_M22:

0DF_HRPOSTN

ZCUS_MAT__ZSD_HEQT

ZC_CUST__ZSD_HEQT

ZSD_HEQT

-


-


Authorization Check

Detail Check for InfoProvider ZM_SD_M22

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

Subselection (Technical SUBNR) 2

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

Check Added for Aggregation Authorization: 0DF_HRPOSTN

Check Added for Aggregation Authorization: ZCUS_MAT__ZSD_HEQT

Check Added for Aggregation Authorization: ZC_CUST__ZSD_HEQT

Check Added for Aggregation Authorization: ZSD_HEQT

Authorizations missing for aggregation (":")

Characteristic 1 2 3

0DF_HRPOSTN Node I EQ : I EQ :

ZCUS_MAT__ZSD_HEQT I EQ : I EQ : Node

ZC_CUST__ZSD_HEQT I EQ : I EQ : I EQ :

ZSD_HEQT I EQ : Node I EQ :

Entries marked with red do not have aggregation authorization

You can find more information about this here 1140831

The authorization check stops here as this selection is no longer needed

Message EYE007: You do not have sufficient authorization

No Sufficient Authorization for This Subselection (SUBNR)

Following CHANMIDs Are Affected:

-


Subselection (Technical SUBNR) 2

Supplementation of Selection for Aggregated Characteristics

Check Added for Aggregation Authorization: 0DF_HRPOSTN

Check Added for Aggregation Authorization: ZC_CUST__ZSD_HEQT

Check Added for Aggregation Authorization: ZSD_HEQT

List of authorizations that provide authorization for selection on ":" (aggregation):

Characteristic 3

0DF_HRPOSTN I EQ :

ZC_CUST__ZSD_HEQT I EQ :

ZSD_HEQT I EQ :

Please guide me what else is required to get the report running.

Thanks and Regards

Sree

Edited by: CRMKNW on Dec 4, 2011 9:43 AM