BAN_ DEFAULT_M BAN_ DEFAULT_Q

BAN_ DEFAULT_ CONNECT

The role BAN_DEFAULT_CONNECT has limited privileges. Users can connect to a database, but cannot access tables. BAN_DEFAULT_CONNECT GRANT CONNECT TO BAN_DEFAULT_CONNECT Note: SCT Banner Security discourages direct grants of any kind.

BAN_ DEFAULT_Q
The role BAN_DEFAULT_Q gives the user privileges to execute all objects and select on all tables in the database GRANT SELECT ANY TABLE TO BAN_DEFAULT_Q GRANT EXECUTE ANY OBJECT TO BAN_DEFAULT_Q

BAN_ DEFAULT_M
The role


BAN_DEFAULT_M gives the user DBA privileges to all tables and all objects in the database. The BAN_DEFAULT_M role ensures access to all appropriate tables, etc. • INSERT ANY, • UPDATE ANY, • DELETE ANY, • SELECT ANY, and • EXECUTE ANY Each role is password-protected, and each password is encrypted.




Additional delivered roles • BAN_ARSYS_REP • BAN_FINANCE_REP • BAN_STUDENT_REP

These are sample roles for reporting, which can be created for each module or as needed.

Can not open GSASECR when login with BANSECR

You are logging into Banner as BANSECR and calling the GSASECR form and getting the error

  *ERROR* User BANSECR not authorized to access GSADBAP
  *ERROR* Access denied, exiting form

As a result you can not get into the GSASECR form to adjust user permissions etc.

Fix
---
Since you can not get into GSASECR to fix the issue you can run this from SQLPLUS to fix the issue

  sqlplus bansecr/u_pick_it
  insert into bansecr.gurucls values ('BANSECR','BAN_FULL_SECURITY_C',SYSDATE,'BANSECR',NULL,NULL);
  commit;

Now retest the GSASECR form as BANSECR to confirm it can be accessed.


Note: Normally you would fix this issue by doing this
  As BANSECR open form GSASECR and enter 
  User ID = BANSECR
  Click "Modifiy"
  Click "User Classes"
  Click on the class "BAN_FULL_SECURITY_C"

Banner error: Invalid PKG_XML or PKG_XML not found

Banner error: Invalid PKG_XML or PKG_XML not found



Resolution:

Uncomment : <entry key="PKG_XML" value="goktxml"/>   in app config xml

Banner 9 General: Form not found or Invalid Object

Banner 9 General

Error:

Form not found or Invalid Object

Root cause: form has not compiled yet


Resolutions:

Check error log
Check problem log
Check pom.xml file dependency

then
Maven update all projects

Banner error not authorized access GOAIMMU

Banner error not authorized access GOAIMMU


Check GURUOBJ

select * from BANSECR.GURUOBJ where GURUOBJ_USERID = 'your userid'



Resolution:

Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
  Values ('GOAIMMU', 'BAN_DEFAULT_M', 'your userid', SYSDATE, 'BANSECR');

Banner 9: Error not authorized access SOACOMP

Banner 9: Error not authorized access SOACOMP

Check GURUOBJ

select * from BANSECR.GURUOBJ where GURUOBJ_USERID = 'your userid'



Resolution:

Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
  Values ('SOACOMP', 'BAN_DEFAULT_M', 'your userid', SYSDATE, 'BANSECR');

Banner error not authorized access SOAIDEN

Banner error not authorized access SOAIDEN


Check GURUOBJ

select * from BANSECR.GURUOBJ where GURUOBJ_USERID = 'your userid'



Resolution:

Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
  Values ('SOAIDEN', 'BAN_DEFAULT_M', 'your userid', SYSDATE, 'BANSECR');

Banner ORA-20104: Invalid version of object is being used ORA-06512: at "BANSECR.G$_SECURITY_PKG"

Ellucian Banner 9 admin

Error:

ORA-20104: Invalid version of object is being used.
ORA-06512: at "BANSECR.G$_SECURITY_PKG", line 821
ORA-06512: at line 1

Root cause:

Java Code of form and DB is mismatched

Resolution:

Ex: GEAPART form:

Option 1: update DB

UPDATE GURAOBJ SET GURAOBJ_CURRENT_VERSION_ALT = '9.3.3', GURAOBJ_ACTIVITY_DATE = SYSDATE WHERE GURAOBJ_OBJECT = 'GEAPART';

Option 2: update code
GEAPART form controller

@ActionTrigger(action="LOAD_CURRENT_RELEASE")
public void Wfacrlv_LoadCurrentRelease()
{

getFormModel().getFormHeader().setCurrentRelease(toStr("9.3.3"));
}

Banner error not authorized to access GUAINIT

Banner error not authorized to access GUAINIT

need to grant access on bansecr

grant select on bansecr.gubiprf to userid;