NyQuest logo
HomeBanner 7 FAQTips & Tricksnavtab
menubar
Import Grants

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;


The contents of www.nyquest.com are Copyright © 2007 by Nyquest Consulting.
Sungard® and Banner® are registered trademarks of Sungard® Corporation.
Nyquest is not affiliated in any way with Sungard®.
All Rights Reserved.