先刪除用戶，在重建用戶，然后賦權(quán)， 腳本放到crontab中定時(shí)執(zhí)行即可 source /opt/.bash_PRofile DATE=$(date +%Y%m%d) sqlplus /nolog <<EOF connect / as sysdba; DROP USER WAPUSER CASCADE; DROP USER JLTGAME CASCADE; CREATE USER "WAPUSER" PROFILE "DEFAULT" IDENTIFIED BY "123456" DEFAULT TABLESPACE "JLTGAME" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; CREATE USER "JLTGAME" PROFILE "DEFAULT" IDENTIFIED BY "JLTGAME123" DEFAULT TABLESPACE "JLTGAME" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK; GRANT CREATE VIEW TO JLTGAME; GRANT CREATE TABLE TO JLTGAME; GRANT ALTER ANY TYPE TO JLTGAME; GRANT CREATE session TO JLTGAME; GRANT CREATE SYNONYM TO JLTGAME; GRANT CREATE TRIGGER TO JLTGAME; GRANT ALTER ANY INDEX TO JLTGAME; GRANT ALTER ANY TABLE TO JLTGAME; GRANT CREATE ANY TYPE TO JLTGAME; GRANT CREATE ANY VIEW TO JLTGAME; GRANT CREATE SEQUENCE TO JLTGAME; GRANT CREATE SNAPSHOT TO JLTGAME; GRANT ALTER TABLESPACE TO JLTGAME; GRANT CREATE ANY INDEX TO JLTGAME; GRANT CREATE ANY TABLE TO JLTGAME; GRANT CREATE PROCEDURE TO JLTGAME; GRANT ALTER ANY TRIGGER TO JLTGAME; GRANT CREATE ANY TRIGGER TO JLTGAME; GRANT ALTER ANY INDEXTYPE TO JLTGAME; GRANT CREATE ANY INDEXTYPE TO JLTGAME; GRANT UNLIMITED TABLESPACE TO JLTGAME; exit EOF imp userid=jltgame/JLTGAME123 file=/backup/52backup/jltgame$DATE.dmp full=y log=/opt/logjltgame$DATE.dmp
