cancel
Showing results for 
Search instead for 
Did you mean: 

additional privilages <SID>adm user for db access

Former Member
0 Kudos

Hi,

currently i can connect sucessfully to databse using ora<sid> user with sysdba privilages.

prdadm>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Sun Nov 12 14:05:33 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba

Connected.

SQL>

but when i tried to connect remote login

SQL> connect orapms/<password>@PRD

ERROR:

ORA-01017: invalid username/password; logon denied

SQL>

but to solve my problem , i need also to create oraprd user in internal db.and assign dba privilages.

Can we create this user ? is it will conflict with OPS$PRDADM?

any idea?

Thanks

Lisa

Accepted Solutions (0)

Answers (1)

Answers (1)

andreas_herzog
Active Contributor
0 Kudos

hmm...the question is: does ora<sid> need to have these privilages? i don't think so...the adm-user is the one who does! ora<sid> does not have a record within SAPUSER table ...OPS$<SID>ADM is the entry....

-> check sapnot 50.088 (will also work for unix)

-> check sapnote 400.214

try to connect via sqlplus and > connect sapr3/<pwd>@<SID> (or sap schema-User) and check if it works! the ops$-user is needed to pass through the password for user sapr3 (or sap schema user) in order to connect to the database...so, if your <sid>adm is able to connect (try for example: sapdba -u / ) and is able to use the br-tools, everything should be ok!

GreetZ, AH