oralce授权

drop user app cascade; 
create tablespace app_data
logging  
datafile 'F:\oracletablespace\app_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local; 
create temporary tablespace app_temp  
tempfile 'F:\oracletablespace\app_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  

create user app identified by app;

grant unlimited tablespace to app;
grant create session to app; 
grant create table,create view,create trigger, create sequence,create procedure to app;