Disconnecting Users

[Allen Karczmarek]

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

[Brian Crabtree · Accepted solution]

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

[Allen Karczmarek]

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