创建Oracle 数据库的 ops$账户,
参考 Note 400241,https://websmp230.sap-ag.de/sap(bD16aCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=400241
不同系统记得修改语句中的SID和HOSTNAME
1、Create the user:
CREATE USER "OPS$SINIPCSBCH\DEVADM" DEFAULT TABLESPACE PSAPSR3USR TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
GRANT RESOURCE TO "OPS$SINIPCSBCH\DEVADM";
GRANT UNLIMITED TABLESPACE TO "OPS$SINIPCSBCH\DEVADM";
GRANT CREATE SESSION TO "OPS$SINIPCSBCH\DEVADM";
2、Create the table SAPUSER as <sid>adm and enter the password:
1)、CREATE TABLE "OPS$SINIPCSBCH\DEVADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
2)、INSERT INTO "OPS$SINIPCSBCH\DEVADM".SAPUSER VALUES ('sapdev', 'abc12345');
3、Create the user OPS$SINIPCSBCH\SAPSERVICEDEV
CREATE USER "OPS$SINIPCSBCH\SAPSERVICEDEV" DEFAULT TABLESPACE PSAPSR3USR TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
CREATE SYNONYM "OPS$SINIPCSBCH\SAPSERVICEDEV".SAPUSER FOR "OPS$SINIPCSBCH\DEVADM".SAPUSER;
CONNECT /
GRANT SELECT, UPDATE ON SAPUSER TO "OPS$SINIPCSBCH\SAPSERVICEDEV";