Re: URGENT: Killing Users using dynamic SQL

From: Martin <mmarhold_at_yahoo.com>
Date: Wed, 12 Jan 2000 14:39:35 +0100
Message-ID: <387c84c5@s21ntpn001.via.at>

Martin wrote in message <387c73eb_at_s21ntpn001.via.at>...
>Trying to kill sessions using dynamic SQL returns the folowing error:
>ORA-01031: insufficient privileges
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
>ORA-06512: at "SYS.DBMS_SQL", line 328
>

Problem solved: The 'alter system' privilege was granted via a role. It needs to be granted directly when using stored procedures.

Thanks again to all who tried to help me! Received on Wed Jan 12 2000 - 07:39:35 CST