topic Re: Authorisation for READ table SOOD in Application Development and Automation Discussions

Authorisation for READ table SOOD

former_member194669 — Tue, 13 Oct 2009 14:30:38 GMT

From a thrid party we are accessing SAP using function module RFC_READ_TABLE, and we are reading table SOOD. But we are getting

a message that

"User not authorized to access QUERY_TABLE"

but same RFC_READ_TABLE we can access all other tables like VBAK, VBEP etc


2009-10-02 13:03:16.041 [INFO ] [pp0] [CONNECTION 0] execute CALLRECEIVE 
2009-10-02 13:03:16.041 [INFO ] [pp0] get a function template from the repository for RFC_READ_TABLE 
2009-10-02 13:03:16.041 [INFO ] [pp0] set the input parameters 
2009-10-02 13:03:16.041 [DEBUG] [pp0] set QUERY_TABLE to SOOD 
2009-10-02 13:03:16.041 [DEBUG] [pp0] table OPTIONS 
2009-10-02 13:03:16.041 [DEBUG] [pp0] +-- set TEXT to OBJTP = 'EXT' AND OBJYR = '31' AND OBJNO = '000000001189' 
2009-10-02 13:03:16.041 [DEBUG] [pp0] table FIELDS 
2009-10-02 13:03:16.041 [DEBUG] [pp0] +-- set FIELDNAME to OBJDES 
2009-10-02 13:03:16.041 [DEBUG] [pp0] +-- set FIELDNAME to FILE_EXT 
2009-10-02 13:03:16.041 [INFO ] [pp0] call RFC module 
2009-10-02 13:03:16.400 [ERROR] [pp0] [CONNECTION 0] error executing CALLRECEIVE: error executing function: User not authorized to access QUERY_TABLE 
2009-10-02 13:03:16.400 [INFO ] [pp0] [CONNECTION 0] execution aborted after: 362 ms

Any Info why we are getting Authorisation issue while accessing using RFC_READ_TABLE

a®

Re: Authorisation for READ table SOOD

RaymondGiuseppi — Tue, 13 Oct 2009 14:42:41 GMT

Read OSS [Note 1012218 - authorization in RFC_READ_TABLE|https://service.sap.com/sap/support/notes/1012218] - check Authorization group for table SOOD ?

Regards,

Raymond

Re: Authorisation for READ table SOOD

Former Member — Tue, 13 Oct 2009 14:51:16 GMT

hi,

user should have a minimum level of authorization for the following authorization objects:

S_RFC

S_RZL_ADM

S_XMI_PROD

S_TABU_DIS

S_ADMI_FCD

For each of these authorization objects, specify full

authorization using the asterisk * wildcard.

Note: Alternatively, we can assign SAP_ALL authorization

to this user.

Thanks,

Arunsri

Re: Authorisation for READ table SOOD

former_member194669 — Tue, 13 Oct 2009 14:52:03 GMT

But why other table can be able read like VBAK, VBEP etic .

Only SOOD is not possible

One more question. If we are using fm SO_SOOD_READ instead of RFC_READ_TABLE whether this issue will solve ?

because this function module is not check authority object

a®

Re: Authorisation for READ table SOOD

RaymondGiuseppi — Tue, 13 Oct 2009 14:56:14 GMT

Check Authorization group for table SOOD (look thru table TBRG, maybe SOAD) is missing.

Regards,

Raymond

Re: Authorisation for READ table SOOD

former_member194669 — Tue, 13 Oct 2009 15:03:36 GMT

Raymond,

User have access for auth object s_tabu_dis .

Can you explain if we are using fm SO_SOOD_READ instead of RFC_READ_TABLE whether this issue will solve ?

a®

Re: Authorisation for READ table SOOD

naimesh_patel — Tue, 13 Oct 2009 16:01:41 GMT

Authorization group SA has been assigned to the table SOOD table. (SE11 > table SOOD > Utilities > Assign Authorization Group).

Your RFC user must have this group assigned in order to read the records from this table.

Regards,

Naimesh Patel