authorizations for Schema user ?

[Former Member]

Hello All,

Getting the following error message in the SM21 system logs

> SQL0551N "SAPSR3" does not have the required authorization For the DDIC user

when Searched, The Following link says "grant DBADM privileges to schema user "

http://forums.sdn.sap.com/thread.jspa?threadID=1873291

how to check the existing previlages of the schema SAPSR3 user in db2

Regards

[Former Member]

Solved the issue by the following execution

db2 grant execute on function SYSPROC.MON_GET_TABLESPACE to SAPSR3

[Former Member]

Hi,

Please check SAP Note 834917 - Oracle Database 10g: New database role SAPCONN.

Regards,

Venkata S Pagolu

[former_member204080]

Hi,

U can check it in syscat.tabauth

[Former Member]

Thanks Murali For the Response

Could u give me the sql to check the available previlages of SAPSR3

Regards

[Former Member]

I did check SYSCAT TABAUTH but ....

Thanks Murali For the Response

Could u give me the sql to check the available previlages of SAPSR3

Regards

[Former Member]

Hi,

Check with below sql query...

select * from syscat.tabauth where grantee='SAPSR3'

Regards.

Rajesh Narkhede

[Former Member]

To All --- My database is DB2 on AIX ,

Hi Venkata and Rajesh Thanks for The response

Also , am looking for a smiple query which displays what previlages the SAPSR3 is having

in the system, so that i can compare this with other and identify any missing previlages

Regards

[Former Member]

Hi All

The Following could be possible solution

db2 grant execute on function SYSPROC.MON_GET_TABLESPACE to SAPSR3

This i get from a remote colleague

is that ok to execute this on a prod box ?

Regards

[Former Member]

Yet to get Any Response , Thinking could have been posted in the following header

SAP NetWeaver - IBM Software Interoperability

Regards