oracle整理
¥¥ 查看已经创建好的表空间:
select default_tablespace, temporary_tablespace, d.username from dba_users d ;
¥¥ 创建表空间
create tablespace db_test datafile ‘D:\oracle\product\10.2.0\userdata\db_test.dbf’ size 50m autoextend on;
¥¥ 查看用户
select * from dba_users;
¥¥ 创建用户
create user syl identified by 123;
alter user syl account unlock;
grant dba to syl;
用户授权
grant coonect ,resource,dba to laowang;
–connect 是链接数据库权限,可以对数据库进行增删改查
–resource 资源使用权限,用来创建表格
–dba 是数据库管理员权限
2.修改密码
alter user laolu identified by laolu123;
3.回收权限
revoke connect,resource from laolu; revoke --回收 connect,rescource --创建以及查询等权限 from --从谁哪里回收
4.给用户加锁或者解锁
加锁: alter user laolu account lock;
解锁: alter user laolu account unlock;
5.删除用户
drop user laowang
drop user syl CASCADE; //级联删除