oracle新建用户

oracle新建用户

建用户：
alter session set "_ORACLE_SCRIPT"=true;

CREATE USER AppUser IDENTIFIED BY ABC123456;
GRANT CONNECT, RESOURCE TO APPUSER;



查询用户在不在？
SELECT USER FROM dual;
SELECT username FROM dba_users;
SELECT username FROM dba_users WHERE username = 'APPUSER';

进入容器后，用新用户连接sqlPlus
sqlplus APPUSER/ABC123456@//localhost:1521/FREE