Re: set role in logon trigger

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 28 Sep 2000 05:34:23 -0700 (PDT)
Message-Id: <10633.118137@fatcity.com>

--0-1714636915-970144463=:26954

Content-Type: text/plain; charset=us-ascii

 Is there any reason why you just don't make the role a default role?

  Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote: I am running 8.1.6 and trying to setup a logon trigger to do a set role command. I had the trigger execute a procedure to do the set command but keep getting errors. I tried having the procedure run as "current user" with no luck. Can this be done??

QL> connect test/test_at_adst
ERROR:

ORA-00604: error occurred at recursive SQL level 1
ORA-01919: role 'BD_USER' does not exist
ORA-06512: at "SYS.DBMS_SESSION", line 80
ORA-06512: at "RTA.ADS_LOGON_ROLE", line 4
ORA-06512: at line 9

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jeffrey Beckstrom
INET: JBECKSTROM_at_gcrta.org

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists

---

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
--0-1714636915-970144463=:26954

Content-Type: text/html; charset=us-ascii

<P> Is there any reason why you just don't make the role a default role?<BR>
<P>&nbsp; <B><I>Jeffrey Beckstrom &lt;JBECKSTROM_at_gcrta.org&gt;</I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I am running 8.1.6 and trying to setup a logon trigger to do a set role command. I had the trigger execute a procedure to do the set command but keep getting errors. I tried having the procedure run as "current user" with no luck. Can this be done??<BR><BR>QL&gt; connect test/test@adst<BR>ERROR:<BR>ORA-00604: error occurred at recursive SQL level 1<BR>ORA-01919: role 'BD_USER' does not exist<BR>ORA-06512: at "SYS.DBMS_SESSION", line 80<BR>ORA-06512: at "RTA.ADS_LOGON_ROLE", line 4<BR>ORA-06512: at line 9<BR><BR>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216) 781-4204<BR><BR>--<BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>--<BR>Author: Jeffrey Beckstrom<BR>INET: JBECKSTROM@gcrta.org<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, Califo!
rnia -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>

<a href="http://photos.yahoo.com/">Yahoo! Photos</a> - 35mm Quality Prints, Now Get 15 Free! Received on Thu Sep 28 2000 - 07:34:23 CDT