How to create database admin user.

[Former Member]

Hi,

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

Thanks

Kunal

[Former Member]

I googled it and found out. Thanks