1.select * from dba_users;
查询所有用户
2.select * from user_users;
查询当前用户
3.select * from all_users;
查询当前用户可以访问的所有用户
4.select * from dba_roles;
查看都有哪些角色
5.select * from user_role_privs;
查询当前用户拥有的权限
6.select * from dba_role_privs;
查询所有用户拥有权限
7.select * from user_tables;
查看当前用户拥有的表
8.select account_status from dba_users where username='SYSTEM';
查询SYSTEM用户是否被锁
9.ALTER USER SYSTEM ACCOUNT UNLOCK;
给SYSTEM用户解锁。
Oracle常用命令
最新推荐文章于 2023-08-01 00:11:56 发布