oracle中创建数据库授权,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;