export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH
alter user system identified by oracle;
alter user sys identified by oracle;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
GRANT ALTER ANY PROCEDURE TO username;
GRANT ALTER ANY TABLE TO username;
GRANT ALTER ANY TRIGGER TO username;
GRANT ALTER ANY TYPE TO username;
GRANT CREATE ANY TABLE TO username;
GRANT DELETE ANY TABLE TO username;
GRANT DROP ANY PROCEDURE TO username;
GRANT DROP ANY SEQUENCE TO username;
GRANT DROP ANY TABLE TO username;
GRANT DROP ANY TRIGGER TO username;
GRANT DROP ANY TYPE TO username;
GRANT DROP ANY VIEW TO username;
GRANT SELECT ANY DICTIONARY TO username;
GRANT SELECT ANY SEQUENCE TO username;
GRANT SELECT ANY TABLE TO username;
GRANT UNDER ANY TABLE TO username;
GRANT UNDER ANY TYPE TO username;
GRANT UNDER ANY VIEW TO username;
GRANT UNLIMITED TABLESPACE TO username;
GRANT UPDATE ANY TABLE TO username;
GRANT CONNECT TO username;
GRANT DBA TO username;
GRANT RESOURCE TO username;
#下面两句主要用于给其他用户赋权限
GRANT insert ANY TABLE TO username;
GRANT execute ANY PROCEDURE TO username;