Get Java Schema/User from a script

[jochen_willeke]

Hey SAP-Community,

I am new to the whole SAP Netweaver thing and currently I am working on a script and need to find out (automatically) which User/Schema is used by a given Netweaver AS Java System. I know about the naming rules (SAPSR3DB and/or SAP<SID>DB) but just in case someone has messed around with that (e.g. due to systemcopies) I want to check. My idea is, to check for some core-tables which MUST belong to the used Schema.

select OWNER,OBJECT_NAME from dba_objects where OBJECT_NAME = '<table name>';

First of all, do you think this is a good idea, and second which table may I use? I am thankfull for any thoughts on this.

Best regards,

Jochen

[Reagan · Accepted solution]

Hello

The database schema for the Java stack is also maintained in the Configtool secure store.

Also you may use these queries.

SELECT USERNAME FROM DBA_USERS;

This will provide you the list of users and there you can find the schema name for Java.

SELECT DISTINCT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OWNER = 'SAPSR3DB';

This will show you the list of objects owned by the schema.

The SVERS table wont list any schema information and I doubt whether the table is available on a Java stack

Cheers
RB