How can I provide access to a user to the Database so that he can run queries? I have already tried it by adding him to the group oper and dba but it doesnot work. sqlplus / nolog cannot find anything.
Basically , I want him to have the same privileges like ora<SID>. He should be able to do almost everything , if not everything, that ora<SID> does. I do not want him to have the password to ora<SID>.
My guess is I wont be able to do it by just adding him to the group. I will have to do it using SQL. If I am right, can someone provide me the sql statements for this. Or any other alternative that would make this work.
<b>OS: </b>HP UX 11.23
<b>Database:</b> Oracle 10.2.0.2
SAP ECC 6.0