oracle中创建数据库用户，并授权

--查看表空间文件路径
select * from dba_data_files where tablespace_name=$TABLESPACE

CREATE TABLESPACE usr_aa DATAFILE ‘+ORADATA/racdb/datafile/usr_aa.dbf‘ SIZE 50 M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED NOLOGGING PERMANENT EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

?

CREATE USER usr_aa IDENTIFIED BY password DEFAULT TABLESPACE usr_aa QUOTA UNLIMITED ON EDU_DATA QUOTA 5 M ON system ACCOUNT UNLOCK ;grant dba to usr_aa with admin option;grant connect,resource to usr_aa with admin option;grant unlimited tablespace to usr_aa with admin option;grant analyze any to usr_aa with admin option;grant create table to usr_aa with admin option;grant drop any table to usr_aa with admin option ;grant alter any table to usr_aa with admin option ;grant comment any table to usr_aa with admin option ;grant select any table to usr_aa with admin option ;grant insert any table to usr_aa with admin option ;grant update any table to usr_aa with admin option ;grant delete any table to usr_aa with admin option ; grant select any sequence to usr_aa with admin option ; grant execute any procedure to usr_aa with admin option ;grant CREATE ANY JOB to usr_aa;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!