oracle新创建用户

1：创建临时表空间
create temporary tablespace nbpbs_data_temp  
tempfile '\oradata\ggfwwwdb\nbpbs_data_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 2048m  
extent management local;  
 
2：创建数据表空间
create tablespace nbpbs_data  
logging  
datafile '\oradata\ggfwwwdb\nbpbs_data.dbf' 
size 150m  
autoextend on  
next 150m maxsize 20480m  
extent management local;  
 
第3步：创建用户并指定表空间
create user nbpbs identified by nbpbs
default tablespace nbpbs_data  
temporary tablespace nbpbs_data_temp;  
 
第4步：给用户授予权限

grant connect,resource,dba to nbpbservice;

--授权
GRANT
CONNECT,                
RESOURCE,               
CREATE  SESSION,         
CREATE ANY SEQUENCE,     
CREATE ANY TABLE,        
CREATE ANY VIEW ,        
CREATE ANY INDEX,        
CREATE ANY PROCEDURE,    
CREATE ANY DIRECTORY,    
ALTER  SESSION, 
ALTER ANY SEQUENCE,     
ALTER ANY TABLE,        
ALTER ANY INDEX,        
ALTER ANY PROCEDURE,    
DROP ANY SEQUENCE,     
DROP ANY TABLE,        
DROP ANY VIEW ,        
DROP ANY INDEX,        
DROP ANY PROCEDURE,    
DROP ANY DIRECTORY,    
SELECT ANY TABLE, 
SELECT ANY DICTIONARY,
INSERT ANY TABLE, 
UPDATE ANY TABLE, 
DELETE ANY TABLE,
DEBUG ANY PROCEDURE,
DEBUG CONNECT SESSION,
exp_full_database,  
imp_full_database     
To nbpbservice;

第5步：发现空间不够大？那就调整一下吧
ALTER DATABASE DATAFILE '\oradata\ggfwwwdb\nbpbs_data.dbf' RESIZE 100M;