create procedure kill_your_session (in_sid in sys.v_$session.sid%type,
in_serial# in sys.v_$session.serial#%type)
as
row_count pls_integer ;
begin
select count (*)
into row_count
from v$session
where username = user and sid = in_sid and serial#
list
ORACLE-L <[EMAIL PROTECTED]>
>cc:
Sent by: Subject: RE: kill session privilage
list
ORACLE-L <[EMAIL PROTECTED]>
>cc:
Sent by:
First
question for the boss, WHY?
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 13, 2004 2:44
AMTo: Multiple recipients of list ORACLE-LSubject: kill
session privilage
My boss want me to
Yes. You can write a procedure using execute immediate and grant him the right to
execute the procedure.
On 2004.01.13 02:44, AK wrote:
> My boss want me to give kill session privilage one of the developer here He doesn't
> have any dba privilage to see session or anything . Is ther
My boss want me to give kill session privilage one
of the developer here . He doesn't have any dba privilage to see session or
anything . Is there any way I can give likited access to him.
Thanks,
ak