oracle01创建表空间

C:\Program Files\feiq\Recv Files




create tablespace  myspace
Datafile 'D:/bb.dbf' size 2m;


create user book1 identified by a123
default tablespace myspace


grant connect,resource ,dba to book1;


drop tablespace myspace


create table userinfo(
id number(10) primary key,
uname varchar2(10),
pwd varchar2(10)


)
修改用户密码
alter user table book identified by a111,
alert user table book account unlock;
drop user book cascade;
revoke dba from book;






drop tablespace tbs_shop
1创建表空间tbs_shop，其中，数据文件名称为shop.dbf，文件大小10M。
create tablespace  tbs_shop
Datafile 'D:/shop.dbf' size 10m;
创建用户shopmgr，用户赋权限 ，该用户可以登录数据库
并指定用户的表空间为tbs_shop
drop user shopmgr cascade;
create user shopmgr identified by a123


default tablespace tbs_shop
--资源使用权限，dba,s数据库管理的最大的权限
grant connect,resource ,dba to shopmgr
修改用户shopmgr的密码为xx123
alter user  shopmgr identified by xx123


解锁scott账户
tiger 


5删除用户shopmgr
drop user shopmgr cascade;