Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Credentials - Oracle

Dear CPS developers

I am new to this forum and new to version 7 and I am struggling with credentials - especially with Oracle credentials. What needs to match where information wise that such a credential would work? How could a test credentials efficiently.

I am trying to set up a small test with a cronacle script that looks like that:

create or replace script "xxx"."xxx_S_ADMIN_REMOTE_SQL"

( "JCS_RUNUSER" in varchar2(30) null

description 'Use this credentials for the JCS_RUNDB job'

nocmdfile

default expr('<db_user>' )

, "JCS_RUNDB" in varchar2(64) null

description 'Perform job in database'

nocmdfile

default expr('db_name' )

)

application "SYSJCS"."xxx"

format "SYSJCS"."GENERIC"

queue "SYSJCS"."xxx"

no verify

as declare

lv_sysdate varchar2(10);

begin

select to_char(sysdate, 'dd-mm-yyyy') into lv_sysdate from dual;

dbms_output.put_line('ln_sysdate: '||lv_sysdate);

end;

/

and a credential that looks like that:

create or replace credential "SYSJCS"."ORACLE"."<db_name>"."<db_user>"

encoded password ''

/

Somehow I always get this error:

ORA-20800: JCS-02370: SYSJCS has no access to ORACLE credentials for <db_user> on system <db_name>

ORA-06512: at "SYSJCS.DDL", line 7556

ORA-06512: at line 3

JCS-00215: in statement RSO_GET_PASSWORD

I tried different versions and it doesn't work.

Many thanks for your support & regards

Stephan

Former Member
Not what you were looking for? View more on this topic or Ask a question