1.创建用户规则
create user bingning --用户:bingning
identified by bingning --密码:bingning
default tablespace SYSTEM --默认表空间 system
temporary tablespace TEMP --临时表空间 temp
ACCOUNT UNLOCK; --解锁
grant dba to bingning; --赋DBA权限
2。oracle 9i系统安装的默认用户:
用户名 密码 权限
sys change_on_install sysdba或者sysopen
system Manager sysdba或者normal
scott tiger normal
创建一个用户,查询dba_users,user_users看用户的密码(在数据库中已经是加密的)和状态
1. create user aaa
identified by aaa
default tablespace system
temporary tablespace temp
account unlock;
grant create session to aaa;
create user bbb
identified by bbb
default tablespace system
temporary tablespace temp
account lock;
grant create session to bbb;
2.在数据字典中dba_users查询用户aaa状态值(密码已经加密),可以看出用户的默认表空间
select *
from dba_users
order by username
3.创建一个用户
CREATE USER "BBB"
IDENTIFIED BY "bbb" PASSWORD EXPIRE
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
4.在SQL/PLUS中连接数据提示密码已经过期
5.修改用户口令
ALTER user BBB IDENTIFIED BY A;
6.创建用户注意:
CREATE USER "CCC"
IDENTIFIED BY "CCC"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT LOCK;
7.在SQL/PLUS中提示用户已经加锁,解锁命令
ALTER user CCC ACCOUNT UNLOCK;
8.监视用户
SELECT *
from v$ session
where user_name='CZGK';
select *
from v$open_cursor
where user_name='jkgk';
注意在同一个用户下显示的SQL语句
9.删除用户
DROP USER CCC;