oracle 10g体系结构及安全管理

1.了解oracle数据库物理结构

2.理解oracle数据库逻辑结构

3.掌握oracle数据库的安全管理

 

一.

--创建一个myspace表空间
create tablespace myspace datafile 'D:\database\myspace01.dbf' size 10M

--修改表空间
alter tablespace myspace add datafile 'D:\database\myspace02.dbf' size 10M
alter tablespace myspace add datafile 'D:\database\myspace03.dbf' size 10M


create tablespace usertt
(
       EdId number not null,
       EdName varchar2(20) not null, 
)

 

create user Student
IDENTIFIED by student123
default tablespace users;

--修改student表
alter user Student
identified by mysecstudent
default tablespace SYSTEM;

--删除student表
drop user Student CASCADE


--授予用户connect,resouree角色
GRANT CONNECT TO Student;
grant resource to Student;


--授予用户查询scott.emp数据库对象的权限
grant select on scott.emp to Student

--授权回收
grant create session,CONNECT,resource to Student;
revoke insert on scott.emp from Student

select * from scott.emp;