Oracle常用命令(2)
- create tablespace 表空间名 datafile ‘D:\a.dbf’ size 50m autoextend on;
- create user 用户名 identified by 密码 + default tablespace ts_1;
grant create session to xiaoming;
create table Goods( id number(5) primary key , name varchar2(20) not null);
grant select on emp to xm;
使xm可以查询scott 的empselect * from scott.emp;
revoke select on emp from xiaoming;
收回权限drop userxm cascade;
删除用户grant select on emp to xm with grant option;
对象权限grant connect to xiaoming with admin option;
系统权限- 权限的维护
- cascade 级联删除