创建用户只分配select 权限

1. 用sys用户登陆， 创建用户并赋权限

create user cc551it identified by "cc551it";
grant connect,resource to cc551it;
grant create synonym to cc551it;


2. 用newccs用户登陆，对cc551it 用户赋select 权限

Select 'grant select on newccs.'||table_name||' to cc551it;' from user_tables;

grant select on newccs.SENDFAX to cc551it;                       
grant select on newccs.SIPBBS to cc551it;                        
grant select on newccs.TEAM_TEAMGROUP_MAP to cc551it;            
grant select on newccs.TEAMGROUP to cc551it;                     
grant select on newccs.EMPLOYEECLASS_SWITCH to cc551it;          
grant select on newccs.TTT to cc551it;                           
grant select on newccs.BHTABLE to cc551it;                       
grant select on newccs.AGENTORDER to cc551it;                    
grant select on newccs.AREA_QUEUE_MAP to cc551it;                
grant select on newccs.BBS to cc551it;                           
grant select on newccs.BUSINESS to cc551it;                      
grant select on newccs.CUST_ADVICE_DETAIL to cc551it;            
grant select on newccs.CUST_ADVICE_ITEM to cc551it;              
grant select on newccs.CUST_ADVICE_LIST to cc551it;              
grant select on newccs.CUSTBUSS to cc551it;                      
grant select on newccs.CUSTCONTACT to cc551it;                   
grant select on newccs.CUSTOMER to cc551it;                      
grant select on newccs.CUSTPHONE to cc551it;                     
grant select on newccs.DAYORDER to cc551it;                      

grant select on newccs.DEVICESP_LIST to cc551it;                 
grant select on newccs.GRAYLIST to cc551it;                      
grant select on newccs.LOOPPREORDER to cc551it;                  
grant select on newccs.MAXID to cc551it;                         
grant select on newccs.OPSERVERLIST to cc551it;                  
grant select on newccs.ORDERS to cc551it;                        
grant select on newccs.OTHERINFO to cc551it;                     
grant select on newccs.PREORDER to cc551it;                      
grant select on newccs.PURVIEW to cc551it;                       
grant select on newccs.REQMON to cc551it;                        
grant select on newccs.ROLELIST to cc551it;                      
grant select on newccs.SCHORDER to cc551it;                      
grant select on newccs.SELAREA to cc551it;                       
grant select on newccs.SERVERLIST to cc551it;                    
grant select on newccs.SERVICE_CITY_LIST to cc551it;             
grant select on newccs.SMSSP_LIST to cc551it;                    
grant select on newccs.SYNCBYKEY to cc551it;                     
grant select on newccs.SYNCTABLE to cc551it;                     
grant select on newccs.ERRORSYNCSQL to cc551it;                  
grant select on newccs.FORWARDCODE to cc551it;                   
grant select on newccs.ORDERCOUNT to cc551it;                    
grant select on newccs.RECKONSTAT to cc551it;                    
grant select on newccs.SYNCOLUMN to cc551it;                     
grant select on newccs.SYNCOLVALUEMAP to cc551it;                
grant select on newccs.USERCOUNT to cc551it;                     
grant select on newccs.USERSTAT to cc551it;                      
grant select on newccs.CLIENTUPDATE to cc551it;                  
grant select on newccs.SYSTEMSET to cc551it;                     
grant select on newccs.TFIELDSLIST to cc551it;                   
grant select on newccs.TM_CARGO_TYPE to cc551it;