1.登录
sqlplus /nolog
conn sys/password as sysdba
sqlplus '/as sysdba'
sqlplus scott/allen@orcl_db as sysdba
2. 创建用户
1.用有dba权限的用户登录:sys用户
2.创建一个新用户:create user abc identified by 123456;
3.授予DBA权限: grant connect,resource,dba to abc;
3.解锁
SQL> alter user 用户名 account lock; (加锁)
SQL> alter user 用户名 account unlock; (解锁)