Oracle-用户管理

Oracle-用户管理

创建只读用户

create user query identified by query default tablespace cc;
grant connect to query ;
grant SELECT ANY TABLE to query;
--grant select on  aaa to query;
--数据字典权限
grant select any dictionary to query;

创建sysdba权限用户

create user zdbackup identified by zdbackup ;
grant sysdba to zdbackup;
grant create session, connect, resource to zdbackup ;

用户解锁

alter user scott account unlock;

用户更改密码

alter user user01 identified by user10;

不知道密码的情况下，修改新密码等于旧密码

select * from dba_users;
FSSC_LINK                      737A7F19A6C8315B
alter user FSSC_LINK identified by values '737A7F19A6C8315B';

删除用户

drop user xxxDROP USER XXx CASCADE