topic Re: Disconnecting Users in Operating System - HP-UX

Disconnecting Users

Allen Karczmarek — Wed, 02 Oct 2002 16:55:43 GMT

Hi,
I am trying to kill certain sessions from a stored procedure in an Oracle database. I've tried to create a cursor to get a list of the sid's and serial#'s to kill. The cursor selects from v$session in a stored procedure (see below). I keep getting the error also listed below. I am connected as system when trying to compile the code. Any suggestions?

Thanks,
Allen

CURSOR TO_BE_KILLED IS
SELECT username, sid, serial#
FROM v$session;

PLS-00201: identifier 'SYS.V_$SESSION' must be declared

Re: Disconnecting Users

Brian Crabtree — Wed, 02 Oct 2002 17:07:01 GMT

You should grant select against the view directly to the user. Stored procedures do not hold grants given through roles in some cases, and almost always when using SYS owned tables.

Format is:
grant select on sys.v_$session to ;

Thanks,

Brian

Re: Disconnecting Users

Allen Karczmarek — Wed, 02 Oct 2002 17:15:48 GMT

Worked like a champ!!!!! THANKS!!!