Re: **Help! Help! **

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sun, 18 Apr 1999 21:35:05 +0200
Message-ID: <7fdc4v$5su$1@weber.a2000.nl>

Haruka Suko wrote
> Is there any way to know the names of active
> users who have stored procedures?

    connect system

    select ses.username "Oracle username"

    ,      ses.osuser "Operating system username"
    ,      rtrim(ses.machine, chr(0)) "Machine"
    from v$session ses
    ,      all_sources src

    where ses.username = src.owner;

Arjan. Received on Sun Apr 18 1999 - 14:35:05 CDT