Checking no of users list from oracle SAP r3 4.7, oracle 9i, Solaris

[Former Member]

Hi,

I need to check if any users were created in client 400 (This client not in use) but we donn't hv user id & password. Also my management wonn't allow to delete sap(I know if we delete sap will be created with passwd: pass).

When login to SQL and execute the command:

<b>select count (1) from sapSID.usr02 where mandt='400';</b>it is giving error as follows: any idea

ERROR at line 1:

ORA-00942: table or view does not exist

Can someone help.

adv thanks

regds

[Former Member · Accepted solution]

Hello Jalli,

to which user does this table belong?

select table_name, owner from dba_tables where table_name like '%USR02%';

You mean from sapSID a DB User e.g sapC11, if DB SID is C11, or not?

Do you have any DB user sapSID (or SAPR3 or SAP<SID>)?

select username from dba_users;

If you have an user sapSID, then you should get a result back, because this table should belong to SAP DB User, like SAPR3 or SAP<SID> etc.

You can log on to DB also with your SAP DB User sapSID:

For that you need an OS User with dba group:

sqlplus /nolog

connect sapSID/pw

or at first log onn with AS SYSDBA

then

select count (1) from sapSID.usr02 where mandt='400'

Best regards

Baran

[Former Member]

Baran,

Yes. I should use sapr3.user02 as our dbuser is sapr3 not sapsid.

done..

Thanks