1.创建表空间
create tablespace testspace datafile 'G:\oracle\tbspace\testspace.dbf' size 4000M
autoextend on next 10M maxsize 3000M;
2.创建用户
create user test identified by "123456" default tablespace testspace;
3.给用户赋权限
grant connect,resource to test ;
grant create any table to test ;
grant delete any table to test ;
grant insert any table to test ;
grant select any table to test ;
grant update any table to test ;
grant unlimited tablespace to test ;
grant execute any procedure to test ;
grant create any view to test ;
grant dba to test ;
create tablespace testspace datafile 'G:\oracle\tbspace\testspace.dbf' size 4000M
autoextend on next 10M maxsize 3000M;
2.创建用户
create user test identified by "123456" default tablespace testspace;
3.给用户赋权限
grant connect,resource to test ;
grant create any table to test ;
grant delete any table to test ;
grant insert any table to test ;
grant select any table to test ;
grant update any table to test ;
grant unlimited tablespace to test ;
grant execute any procedure to test ;
grant create any view to test ;
grant dba to test ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12060579/viewspace-1979993/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
jQuery关于radio的取值与赋值
请登录后发表评论
登录
全部评论
