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

[Former Member]

Hi Jochen,

SQL command mentioned by you looks good.

Additionally you may check following scrips

Select username from dba_users; -> This will list down all the database users include schema user.

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.

You may go with table SVERS as starting points.

Regards,

Deepak Kori