Friday, July 10, 2009

Unlocking HR and OE Schema in Oracle Database

We can use SQL * Plus to unlock OE and HR schema come along with Oracle Database later than version 9i as follow;

ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to hr;

ALTER USER oe IDENTIFIED BY OE ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to OE;

Default password for HR is "hr".

Tuesday, May 19, 2009

How to Disconnect from Network folder

There is a network directory like "\\ABCD\\EFGH" in my office server that I used to access. I need to log-in to the directory for only first time. Now I want to disconnect it from the server because I want to test my program which need to access network directory with user name and password. So I find a way to disconnect from server. I found out as follows:

Click Start and open Run
In that window type: control userpasswords2
Press OK
in the next window go to the secon tab on top, named: Advanced
and from there open: Manage Passwords
There you should see if there is a password stored for the address that you have mentioned
If yes then delete it and close the windows with OK
try to connect again to that address, it should prompt for authentication. Do not check the Remember option...

(Source: http://en.kioskea.net/forum/affich-35879-to-disable-auto-login-network-share-folders)