oracle创建用户与赋权限

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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12060579/viewspace-1979993/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12060579/viewspace-1979993/