Authorization Error Log.

[Former Member]

Hello,

Did any one come across this type of error log,

where it says "authorized" and again "not authorized"

it performs a Salesorg=BP01 and again "NOT Salesorg=BP01"

and I am passing the Salesorg value BP01 by analysis authorization.Also, I have taken care of the special characteristics via different analysis authorizations

Here i am not able to post the error log as you see in RSECADMIN.Just posted the contents from Main Check section from the log.

Contents:

SQL Format:

BILLTOPRTY = ':' AND

SALESORG = 'BP01' AND <<<-------

SOLD_TO = ':' AND

TCAACTVT = '03' AND

TCAKYFNM = '0GR_WT_KG'

Result

Authorized

Contents:

SQL Format:

BILLTOPRTY = ':' AND

<u>NOT SALESORG = 'BP01' AND</u> <<<<-----

SOLD_TO = ':' AND

TCAACTVT = '03' AND

TCAKYFNM = '0GR_WT_KG'

Result

Not Authorized

Thanks In Advance.

Regards

Sreeni.

[klaus_werner · Accepted solution]

Hi Sreeni,

you probably have a selection in your query on more salesorgs than just BP01 (maybe * on salesorg). That selection is checked against your authorization. Now the authorization check tries to find matching authorizations. It finds one for BP01. For that part of the selection the check is successful. Now it needs to find other authorization that maybe cover the rest (everything but BP01 because that is already authorized). That's why it looks for "NOT BP01". If it is not able to find anything else the query will fail. So the reason for failure is that (one of) the query selection(s) is not restricted to BP01.

Regards, Klaus