Oracle command to lock,unlock and change password of a user

Oracle commands

  • to lock and unlock a user
alter user user_name account lock;

alter user user_name account unlock;

  • To change a user's password in Oracle,
alter user user_name identified by new_password;
user_name is the user whose password you wish to change.
new_password is the new password to assign.



user_name must be substituted with the real username.
new_password with the password.

Comments

Post a Comment

Popular posts from this blog

CDbConnection failed to open the DB connection mysql 8

Image
While accessing web configured with mysql 8 and php and you see the following error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client OR  PHP Fatal error:  Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]  It maybe due to  PHP devs might have not implemented the MySQL's 8.0 connection protocol ( auth with caching_sha2_password ) within the newer PHP versions. If you want to use mysql >= 8 and you dont care about caching_sha2_password,  If you are running a fresh install of mysql 8, just select the second option as shown in the image. Otherwise, you need to  configure MySQL 8.0 to run in mysql_native_password mode. As it can't configured in my.cnf, change the user profile as:- ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUs...
Read more

How to replace find -maxdepth option in Solaris Operating System using -prone

 In linux we normally use the option -maxdepth with the find command to report all files and links in the currect directory, not recursively   for example:- find /some/directory/ -maxdepth 1 -type f -name *.log    But when we use the same in Oralce Solaris OS, the command will give error as maxdepth is not an option recogonized in the system. We can replace it with -prone and the syntax is as follows:- find /some/directory/* -prune -type f -name *.log     this should also work with IBM-AIX OS    
Read more

IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect

If  trying isql from server gives the following error, IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Then check the results of following commands in servers odbcinst -q -s odbcinst -q -d if you find any error means that the server is unable to read both odbc.ini and odbcinst.ini files. To resolve this configure the environment variable of server as  export ODBCSYSINI=/etc/ export ODBCINI=/etc/odbc.ini this should fix the error.
Read more