How can we pass Oracle username/password programmically?
i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 14, 2009 5:57 AM
UPDATED:
May 15, 2009 2:35 PM
Answer Wiki:
You will need to disconnect form the database, and connect again using different credentials. You can do it with the help of the LOGOUT and LOGON built-in procedures.
From the help:
<pre>PROCEDURE LOGON
(username VARCHAR2,
password VARCHAR2);
PROCEDURE LOGOUT;
</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Do you want to do this from a Forms application ? if so, what version ? if not, from where ?
yes, i want it on form application. Oracle 8i and Developer 6i