oracle新建用户操作
–查询表空间
select * from dba_tablespaces;
–查询表用户
select * from dba_users;
select * from dba_users where username=‘DEV_OFFLINE’
–创建新用户(不指定表空间与临时表空间,默认:DEFAULT_TABLESPACE=USERS,TEMPORARY_TABLESPACE=TEMP)
create user dev_offline identified by 123456;
–给用户赋权限
grant create session to dev_offline;–赋予create session的权限 一定要有;
grant create table,create view,create sequence to dev_offline;–赋予创建表,创建视图,创建序列的权限;
grant unlimited tablespace to dev_offline;–赋予使用表空间的权限(不给不用使用insert、update、delete)