Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Friday, April 20, 2018
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"
Subscribe to:
Post Comments (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
-
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1525 ORA-29261: bad argument ORA-29273: HTTP request failed ...
-
Banner 9 Admin: Invalid Object Name fix do steps: A record in GUBOBJS with a UI Version of D. • Records in GURAOBJ to define the defau...
-
chown root $ORACLE_HOME/bin/extjob chmod 4750 $ORACLE_HOME/bin/extjob chown root $ORACLE_HOME/rdbms/admin/externaljob.ora chmod 640 $ORA...
No comments:
Post a Comment