1.创建一个名为DAVID的用户,口令为davidpass,并授予其连接数据库和创建表对象的权限。同时授予其访问另一用户MARTIN的表TEST的权限.
[注]作业要求
(1)作业以sql脚本的方式上交,形式为班级名+学生姓名+章节号,如:“35张三5.sql”.
(2)对于题目中未给出的数据对象结构及数据,要创建数据对象并给出测试数据,保证代码可直接执行.
CREATE USER DAVID
IDENTIFIED BY davidpass
DEFAULT TABLESPACE users;
GRANT CREATE session to DAVID;
grant create table to DAVID;
CREATE USER MARTIN
IDENTIFIED BY martin123
DEFAULT TABLESPACE users;
grant resource to MARTIN;
CREATE TABLE TEST (
ID NUMBER(10,0),
sex VARCHAR2(30),
test VARCHAR2(40),
RELAMASTER VARCHAR2(100)
)
GRANT SELECT ON TEST TO DAVID;
GRANT UPDATE ON TEST TO DAVID;
select *
from MARTIN.TEST;