https://blog.csdn.net/xiewendong93/article/details/53638770
新增用户
create user zzg identified by zzg123;
新增表空间chuangda :
create tablespace ts_zzg datafile 'f:\ts_zzg\zzg_data.dbf' size 200M;
还需要将表空间分配给用户
alter user zzg default tablespace ts_zzg;
为用户分配权限
grant create session,create table,create view,create sequence,unlimited tablespace to zzg;
查询用户分配的表空间
select username,default_tablespace from dba_users;
查询用户的权限
select *from session_privs;
删除用户
drop user zzg cascade;
删除表空间
drop tablespace ts_zzg including contents and datafiles cascade constraint;
oracle数据库基本操作
最新推荐文章于 2023-06-02 09:52:49 发布