Create user authorization and Change Password in Oracle

This article describes how to create a user authorization and change a password in Oracle, including creating a user first, then logging on to the user and authorizing and changing the password. I hope this article will help you understand how to create user authorization in Oracle.

After 10 Gb of Oracle, log in with the default username and password scott/tiger/orcl to create a new user and use Oracle to create user authorization:

 
 

  
  
create user test1 identified by test1;  
  
  
grant connect,resource to test1; 
 
 

Log in with test1:

 
 

  
  
sqlplus test1/test1 
 
 

First, log on with the Administrator account (you must have the permission to modify the user) system

 
 

  
  
Alter UserSys identifiedBy123; (sys is the user name, 123 is the password)
 
 

If you log on with sys:

 
 

  
  
connect sys/oralce as sysdba; 
 
 

Log On with system:

 
 

  
  
connect system/oracle;