Authorisation for READ table SOOD

[former_member194669]

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®

[RaymondGiuseppi]

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

[former_member194669]

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®

[RaymondGiuseppi]

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

Regards,

Raymond

[former_member194669]

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®

[Former Member]

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

[naimesh_patel]

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