1.连接
SQL>connect 用户名/口令
2显示当前连接用户
SQL>show user
3查看Orcal数据库管理系统所有的用户
SQL>select * from all_users;
4创建用户
SQL>create user "用户名" identified by"口令" DEFAULT TABLESPACE "USERS " TEMPORARY TABLESPACE "TEMP " ACCOUNT UNLOCK;
5给用户分配连接权限
SQL>Grent "connect" to "用户名";
6修改用户口令
SQL>Alter "用户名" identified by "新口令";
7修改用户角色
SQL>ALTER USER "user_id " DEFAULT ROLE ALL
8查询当前用户所有对象
SQL>select * from tab;