Re: conditional sql scripts?

Kirill Richine wrote:

> I would like to check, in the beginning of my sql script, the user
> name who is running it, and if this user is not the right one, not to
> execute the rest of the script.
>
> Is it possible to do?

Yes, just use PL/SQL. It has IF's, LOOP's, Variables and much more...

-- 
----------------------------------------------------------
           IMSoft - Dipl.-Ing. Michael Karg
             Graf Starhemberggasse 32/2/3
                      1040 Wien
                       Austria
----------------------------------------------------------
e-mail   : karg_at_uranus.tuwien.ac.at
           michael.karg_at_bigfoot.com
           +436641015732_at_text.mobilkom.at
Tel & Fax: ++43/1/5056190
A1       : ++43/664/1015732
WWW      : http://uranus.tuwien.ac.at/~karg/imsoft.html
           http://titania.tuwien.ac.at/~karg/imsoft.html