How to grant sysdba role

Hi,I'm working this on my PC.How to grant sysdba role to a database user. How to test it on my system. Is it necessry to configure tns&listener files. Please explain me
Thanx in advance,
:confused: KVL Narayana:confused:

Hi
to grant sysdba to a user
user the command "grant sysdba to ;"

if you are connect to a remote database using your pc,configure the listener and the tns.
gopu

You don't want to grant sysdba privs to a database user.
Very bad mojo.

why not, it means everything is auditable then - lock down the oracle os account so no generic logins, grant the dbas sysdba to own user id's then can see who is logging in to change stuff

Quote:

---

Originally Posted by davey23uk

why not, it means everything is auditable then - lock down the oracle os account so no generic logins, grant the dbas sysdba to own user id's then can see who is logging in to change stuff

---

Davey, my wild guess is OP plans to just grant SYSDBA to a final user -like a clerck; am I right kvlnarayana?

Thanx all for the replies.I just want to know it.thats it.i dont want to grant it to each n every one.

You should be publicly caned and placed in a stockade for even considering this!