After a full database import, the following grants need to be re-excuted
on a Banner® database. Run this as the SYS user.
grant select on DBA_ROLE_PRIVS to BANSECR;
grant select on DBA_SYS_PRIVS to BANSECR;
grant select on DBA_ROLES to BANSECR,BANINST1;
grant select on DEFROLE$ to BANSECR;
grant select on USER$ to BANSECR;
grant execute on DBMS_PIPE to PUBLIC;
grant execute on DBMS_LOCK to PUBLIC;
grant execute on DBMS_SQL to PUBLIC;
grant alter user to bansecr;
grant select any dictionary to baninst1;
grant select on gubobjs to bansecr;
grant create type to BANINST1;
grant create table to BANINST1;
grant execute on SYS.DBMS_FLASHBACK to BANINST1;
grant execute on SYS.DBMS_FLASHBACK to INTEGMGR;
grant select any dictionary to BANSECR;
grant execute on dbms_rls to BANINST1;
grant execute on dbms_session to BANINST1;
grant create any context to BANINST1;
grant select any dictionary to BANINST1;
GRANT AQ_ADMINISTRATOR_ROLE to baninst1;
GRANT EXECUTE ON DBMS_AQADM TO baninst1;
GRANT EXECUTE ON dbms_aq TO baninst1;
execute DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE ('ENQUEUE_ANY', 'baninst1', FALSE);
execute DBMS_AQADM.GRANT_TYPE_ACCESS ('baninst1');
grant drop public synonym to NLSUSER;
grant insert on gurdmod to nlsuser;
grant select on gobeacc to bansecr;
grant create any directory to BANINST1;
grant drop any directory to BANINST1;
grant administer database trigger to BANINST1;
grant alter any trigger to BANINST1;
grant execute on WFCKGSSO to BANINST1;
grant execute on WFIKWIBC to BANINST1;
grant execute on GOKDBMS to WFSSO;
grant connect to BANSSO;
grant alter user to BANSSO;
grant resource to BANSSO;
grant select on dba_users to BANSSO;
grant create public synonym to BANSSO;
grant drop public synonym to BANSSO;
grant insert on general.gurdmod to BANSSO;
grant select on dba_policies to saturn;