RE: kill session privilage

2004-01-14 Thread Mark Richard
] cc: Sent by: Subject: RE: kill session privilage

RE: kill session privilage

2004-01-14 Thread Goulet, Dick
] cc: Sent by: Subject: RE: kill session privilage [EMAIL PROTECTED

RE: kill session privilage

2004-01-14 Thread Jacques Kilchoer
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#

Re: kill session privilage

2004-01-13 Thread Mladen Gogala
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 there any way I

RE: kill session privilage

2004-01-13 Thread Goulet, Dick
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