DBUSER rights and role [message #584867] |
Mon, 20 May 2013 02:01 |
|
nilesh_pawaskar
Messages: 16 Registered: April 2012 Location: Mumbai
|
Junior Member |
|
|
Dear all,
I used to find out locked table and session from database with the help of below mention query with SYS user but i want to hand over the user session kill role to location level IT person so i have created one user in database named as rab and i have given "select any table,alter session and Grant dba to that rab user,but with the help of that user they wiil drop and delete any table also (as with this user they have to only find the locked object and kill that sesion) ,so can you pls help me as which rights and role i have to gave for this user.
Pls find the mentioned query
col owner format a12
col object_name format a25
col ORACLE_USERNAME format a15
col OS_USER_NAME format a15
col OBJECT_TYPE format a15
set lines 140
select l.OBJECT_ID,o.owner,o.OBJECT_NAME,o.OBJECT_TYPE,SESSION_ID,ORACLE_USERNAME,OS_USER_NAME,LOCKED_MODE
from v$locked_object l,dba_objects o
where l.OBJECT_ID=o.OBJECT_ID
Regards,
NIlesh
|
|
|
|
|
|