oracle新建用户及赋予权限

—–创建用户：
conn sys/change_on_install as sysdba;
create user test identified by test;
grant connect to test with admin option;
grant dba to test with admin option;
grant resource to test with admin option;
grant unlimited tablespace to test with admin option;

—-创建表空间：
create tablespace TSP_BBS
logging
datafile ‘D:\oracle\product\10.2.0\oradata\orcl\TSP_BBS.DBF’
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

将表空间分配给用户：
alter user test default tablespace TSP_BBS;

给用户授权：
为用户赋予connect和resource权限：
grant connect,resource to test;
赋予这些权限后就可以

grant create session,create table,unlimited tablespace to test;

grant connect, resource to test;
grant connect to test;
grant create indextype to test;
grant create job to test;
grant create materialized view to test;
grant create procedure to test;
grant create public synonym to test;
grant create sequence to test;
grant create session to test;
grant create table to test;
grant create trigger to test;
grant create type to test;
grant create view to test;
grant unlimited tablespace to test;
alter user test quota unlimited on TSP_BBS;