From: Karg Michael Subject: Re: conditional sql scripts? Date: 1997/05/06 Message-ID: <336F86B0.2B1B6C0D@uranus.tuwien.ac.at>#1/1 References: <5knh5v$igv$2@scapa.cs.ualberta.ca> To: Kirill Richine X-Priority: 3 (Normal) Organization: IMSoft Reply-To: karg@uranus.tuwien.ac.at Newsgroups: comp.databases.oracle.tools 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@uranus.tuwien.ac.at michael.karg@bigfoot.com +436641015732@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