Can not find the Schema SAPSR3

[Former Member]

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.

[Former Member]

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,

[Former Member]

Hello ,

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

Regards ,

Santosh Karadkar

[Former Member]

Hi Pranav,

Check <b>dba_tables</b> table.

You will find one field OWNER.

See what is the OWNER of tables.

Regards,

payal Patel

[Former Member]

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

[Former Member]

I tried and it is still not working.

From

PT.

[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

[Former Member]

Hi,

What is the schema name given during installation ?

You can also try SAP<SID>.USR02.

Best Regards,

Anamika

Reward pts, if helpful