Oracle数据库添加新的用户和密码的sql命令

	create temporary tablespace cac_temp tempfile 'D:\oracleDB\temp\rbps.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

	create tablespace cac_data     
	logging     
	datafile 'D:\oracleDB\cac_data.dbf'   
	size 50m    
	autoextend on    
	next 50m maxsize 20480m     
	extent management local;          
	 
	create user cac identified by Rfid123456
	default tablespace cac_data    
	temporary tablespace cac_temp;        

	grant connect,resource,dba to cac;

	grant select on SYS.V_$LOCKED_OBJECT TO cac;
	grant select on  SYS.DBA_OBJECTS TO cac;
	grant select on SYS.V_$SESSION  TO cac;
	grant select on SYS.V_$PROCESS TO cac;

	注意：直接复制到sqlplus窗口即可使用；