查询所有用户

1
SELECT * FROM dba_users;

创建用户

1
CREATE USER blog IDENTIFIED BY blog;

用户赋权

1
2
GRANT CREATE SESSION TO blog;
GRANT connect,resource TO blog;

查看用户权限

1
2
3
SELECT * FROM user_sys_privs;//查看当前用户所有权限

SELECT * FROM user_tab_privs;//查看所用用户对表的权限

修改用户密码

1
2
3
ALTER USER system IDENTIFIED BY system;

ALTER USER sys IDENTIFIED BY sys;