Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 23c create user values Tips

2022-12-20

Oracle 23c create user values Tips

create user via same password

SYS@cdb1> alter session set container=pdb1;

Session altered.

SYS@cdb1> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 3 PDB1 			  READ WRITE NO
SYS@cdb1> create user lin1 identified by oracle123;

User created.

SYS@cdb1> grant create session,connect,resource to lin1;

Grant succeeded.

SYS@cdb1> select name,password,spare4 from user$ where name='LIN1';

NAME				PASSWORD SPARE4
------------------------------- -------- ----------------------------------------------------------------------------------------------------
LIN1					 S:5C99D4EC0ECB789E3F6C20FD6540CBEC53E0D6F1DD9B549183E0F76FD6E8;T:8B2315DEEE500DB9A233B8CC58B25EC9E17
					 F1A59D8DEEF0D4CA7D6B3479B3C4818E3A1C19245B93A1104146CB5F4CD76A45F29398E1488A4FFC1135327F7BEA7A7C896C
					 413897D77E4C682713370E2D3


SYS@cdb1> create user lin2 identified by values 'S:5C99D4EC0ECB789E3F6C20FD6540CBEC53E0D6F1DD9B549183E0F76FD6E8;T:8B2315DEEE500DB9A233B8CC58B25EC9E17F1A59D8DEEF0D4CA7D6B3479B3C4818E3A1C19245B93A1104146CB5F4CD76A45F29398E1488A4FFC1135327F7BEA7A7C896C413897D77E4C682713370E2D3';

User created.

SYS@cdb1> grant create session,connect,resource to lin2;

Grant succeeded.

SYS@cdb1>  conn lin1/oracle123@pdb1
Connected.
LIN1@pdb1> conn lin2/oracle123@pdb1
Connected.
LIN2@pdb1> 

Reference

Oracle Database 19c / SQL Language Reference/ CREATE USER

Have a good work&life! 2022/12 via LinHong


Similar Posts

Comments