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"

No comments:

Post a Comment

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...