Skip to Content
avatar image
Former Member

Can not find the Schema SAPSR3

All,

I was trying the unlock the SAP* password

I went to SQL server query analyzer

delete from table SAPSR3.USR02 where bname = SAP*

and MANDT = 000

I got the error message saying

the object SAPSR3.USR02 is not found.

I tried SAPECSDB.USR02 for the same query but same message.

Please advise.

From

PT.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Aug 22, 2007 at 04:24 PM

    Hi Pranav,

    There is the sql to retreive the owner for your tables:

    SQL> select owner from dba_tables where table_name = 'USR02';

    OWNER

    -


    SAPED5

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 19, 2007 at 08:04 PM

    Hi,

    What is the schema name given during installation ?

    You can also try SAP<SID>.USR02.

    Best Regards,

    Anamika

    Reward pts, if helpful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 05:36 AM

    Hi Pranav,

    As Anamika said, you can try with SAP<SID>.USR02 or SAPR3.USR02.

    Either of them should work.

    By Default SAPSR3 is the schema id in ECC 6.0 , if you don't change it during installation.

    and in ECC 5.0 it is SAPR3

    Regards,

    Payal Patel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hey Pranav,

      Its sapr3.USR02 else <SID>.USR02. Keep in mind USR02 should be in capital.

      It will work now.

      Its not sapsr3.

      Thanks & Regards

      Vivek

  • avatar image
    Former Member
    Aug 21, 2007 at 04:29 AM

    Hi Pranav,

    Check <b>dba_tables</b> table.

    You will find one field OWNER.

    See what is the OWNER of tables.

    Regards,

    payal Patel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 05:58 AM

    Hello ,

    Check that the value of environment variable MSSQL_SCHEMA for correct environment variable

    Regards ,

    Santosh Karadkar

    Add comment
    10|10000 characters needed characters exceeded