查询所有数据库用户

select * from dba_users

查看数据库名称

select name from v$database

查看权限

select * from user_sys_privs

修改某个用户的密码

alter user scott identified by tiger