I want to have a connections which stays activated:<br><br>cn=cx_Oracle.connect("dataset", "lowprivuser", "password")<br><br><br>and change the user of that connection.<br><br>Reason: I want to have a web application, which connects ONE TIME (per process/thread) to Oracle, and switches the privileges on the fly.
<br><br>I looked into "SET ROLE <ACTIVEUSERax>"; but as much as I understand thats pureley additional, so:<br><br>cn=cx_Oracle.connect("dataset", "lowprivuser", "password")<br>
# gives the privs of "lowprivuser"<br>cs=cn.cursor()<br><br>cs.execute ("SET ROLE USERFISCH identified by secret2006")<br><br>then gives the privs of "lowprivuser" plus the privs of USERFISCH,
<br><br>and an additional<br><br>cs.execute ("SET ROLE USERFOO identified by othersecret")<br><br>adds the privs of "USERFOO", WITHOUT loosing those of USERFISCH.<br><br><br>Is there any way to do this?
<br><br>Best wishes,<br><br>Harald<br><br><br><br><br><br clear="all"><br>-- <br>GHUM Harald Massa<br>persuadere et programmare<br>Harald Armin Massa<br>Reinsburgstraße 202b<br>70197 Stuttgart<br>0173/9409607<br>-<br>Let's set so double the killer delete select all.