oracle默认三个默认用户
sys、system、Scott
oracle 10g
Scott默认是锁定
创建用户:
用数据必须启动两个服务一个监听,一个实例
lsnrctl start启动监听
oradim -starup -sid orcl 启动实例
sql /as sysdba
show user;
create user lisi identified by lisi;
sqlplus lisi/lisi
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
(
create table mytable(id int);
insert into mytable values(1);
select* from mytable;
drop table mytable;
)
revoke create table from lisi;
select *from user_sys_privs;//查看本用户有那些系统权限