I checked and it works like a charm. Here is the PL/SQL block that I
ran:
11:00:47 SQL select sid,serial# from v$session where username='SCOTT';
SIDSERIAL#
-- --
10535
Elapsed: 00:00:00.50
11:01:10 SQL ed 1
11:01:32 SQL /
SIDSERIAL#
Thanks to all who replied.
Regards
Lee
-Original Message-
Sent: 18 April 2001 00:10
To: Multiple recipients of list ORACLE-L
Hi All,
Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for
this
as PL/SQL does not support ALTER SYSTEM directly.
@ Regards,
@
Are you sure that "execute immediate" doesn't support "alter system"
command? Maybe it's a bug? Which version, which OS?
-Original Message-
Sent: Tuesday, April 17, 2001 7:10 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Further to that, it is necessary to use DBMS_SQL or native
Native dinamic SQL is execute immediate.
Alex Hillman
-Original Message-
Sent: Wednesday, April 18, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
Are you sure that "execute immediate" doesn't support "alter system"
command? Maybe it's a bug? Which version, which OS?
Lee,
In
short, you can't achieve this within Oracle domain short of granting ALTER
SYSTEM to user in question or going via PL/SQL procedure owned by other, more
protectedschema.
However, a tool like TOAD will provide similar capability for you - a
user is capable to "cancel" long running
Create a procedure as SYS (or someone else powerful)
which does the 'alter system' and then grant just the
proc to the user
hth
connor
--- lerobe - Lee Robertson [EMAIL PROTECTED]
wrote: All,
Is there a method for allowing a non DBA user to
kill their own (and only
their own) session. I
I don't think you can kill yourself anymore, at least in 8.1.6. Even as a DBA, Oracle
wouldn't let me off myself...
Note to ALL: ENOUGH WITH THE POLITICAL CLAPTRAP ALREADY!!!
[EMAIL PROTECTED] 04/17/01 11:26AM
All,
Is there a method for allowing a non DBA user to kill their own (and only
Hello,
Li,
I
believe, stored procedure is the best and simplyest way for this purpose. There
is nothing wrong giving ALTER SYSTEM to _procedure owner_. End user will
be limited to execute this procedure only, and will not require ALTER SYSTEM for
him/herself.
Best
regards,
Vadim
Hi All,
Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this
as PL/SQL does not support ALTER SYSTEM directly.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 18 April 2001