本文介绍了一组Oracle数据库中用户管理的具体操作案例，包括创建用户、设置默认表空间、临时表空间、查看活动账户状态、授权及撤销权限、修改密码及解锁账户等关键步骤。
create user yun3151 identified by yun3151
default tablespace myschool
temporary tablespace temp
desc dba_users
select username from dba_users
where account_status='OPEN'
grant connect,resource to yun3151
revoke connect ,resource from yun3151
alter user yun3151 identified by yun
alter user yun3151 account unlock
drop user yun3151 cascade
default tablespace myschool
temporary tablespace temp
desc dba_users
select username from dba_users
where account_status='OPEN'
grant connect,resource to yun3151
revoke connect ,resource from yun3151
alter user yun3151 identified by yun
alter user yun3151 account unlock
drop user yun3151 cascade
扫一扫
129
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
