1.登陆系统dba
sqlplus sys/sys as sysdba;
2.创建用户名密码
create user test identified by test;
3.赋予create session 的权限(登陆连接权限)
grant create session to test;
4.授予创建表的权限
grant create table to test;
5.授予表空间的管理权限
grant unlimited tablespace to test;
1.登陆系统dba
sqlplus sys/sys as sysdba;
2.创建用户名密码
create user test identified by test;
3.赋予create session 的权限(登陆连接权限)
grant create session to test;
4.授予创建表的权限
grant create table to test;
5.授予表空间的管理权限
grant unlimited tablespace to test;