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,

    I think we can make it simple by just finding out what is the name of the schema that is mapped for the default temporary tablespace for Java DB.

PLease find the attached screenshot...

You can use this way to find out what is the schema for java in this way too I believe.

Thanks and Regards,

Vimal

[jochen_willeke]

Thanks to all repliers,

Maria Joseph, your answer seems to be the most helpfull for my purpose. I will stick with this.

Best Regards,

Jochen

[Former Member]

Thanks Jochen.

Kindly close the thread if your query is answered.

Thanks and Regards,

Vimal