Skip to Content
avatar image
Former Member

authorizations for Schema user ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 24, 2012 at 05:37 PM

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

    SAP NetWeaver - IBM Software Interoperability

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 25, 2012 at 05:53 AM

    Hi,

    U can check it in syscat.tabauth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Feb 26, 2012 at 07:59 PM

    Hi,

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

    Regards,

    Venkata S Pagolu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2012 at 11:29 AM

    Solved the issue by the following execution

    db2 grant execute on function SYSPROC.MON_GET_TABLESPACE to SAPSR3

    Add comment
    10|10000 characters needed characters exceeded