switching user in Oracle
RajivYFeb 28 2008 — edited Feb 28 2008-----Please have a look at this link -
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12015.htm#i2697450
It explains how one can 'switch' users in Oracle using the connect command. The purpose as I have explained earlier is to ensure that each user have their own separate ids. And also, that they stop using the production system user id directly, but rather connect to that id, whenever required. --------
Hi friends,
above is the requirement from one of our application owner . They want to switch user from DB level. I am really confused with this as never did it as a DBA...
I am a physical DBA who is taking care of their DB which is hosted in a Solaris 10 server. DB version is Oracle 10.2.0.3 enterprise.
Any quick response is highly appreciated..!!