How to create a new databse user for SAP DB

[daixiong_jiang3]

Hi Gurus,

We have an SAP system based on Oracle Database, and now we want to create an user to connect to the oracle database directly,but we have failed so many times and it seems impossible.

As you know, the followin database user will be created automaticlly during the installation:

USER /////////////////////TABLESPACE

DBSNMP//////////////////////////SYSAUX

DIP////////////////////////////////// SYSTEM

OPS$CEDADM/////////////// SYSTEM

OPS$ORACED///////////////SYSTEM

OPS$SAPSERVICECED//SYSTEM

ORACLE_OCM 25///////////SYSTEM

OUTLN///////////////////////////SYSTEM

SAPSR3////////////////////////PSAPSR3USR

SYS 0////////////////////////////SYSTEM

SYSTEM////////////////////////SYSTEM

TSMSYS////////////////////////SYSTEM

And what we want to do is to create an user refer to SAPSR3 and just allow the new user to access the specificed tables.

We have tried this in PLSQL several times,:

1.log on using SAPSR3: the user SAPSR3 does not have enough authorization to create user.

2.log on using SYSTEM:we can create the user but the tablespace is not the one we want, which will lead to the error"table or view not exist"

so could you pls help to provide some ideas?

Thanks and regards.

Dario

[daixiong_jiang3]

issue resolved.

just use the ADDATIONAL tablespace like sapsr3.mara instead of mara.

[Former Member]

You have to create a user as system (connect /as sysdba) and grant access to certain tables or schema to this user.

Kind regards,

Mark