Banner 9 : add checkbox into table

Banner 9 : add checkbox into table

<panel class="Canvas" height="800px" id="AAA" name="AAA" width="1800px">
        <interactionBlock name="BA"/>
        <gridlayout cols="1" orientation="horizontal">
            <gridcell>
                <gridview block="BA" height="800px" name="BA" width="1800px">
                    <viewheader>
<viewcolumn  label="User  Info" member="BA_INFO" name="baInfoInd" width="50px">
                            <editor>
                                <checkbox falsevalue="N"  value="Y" othervaluestate="unchecked"/>
                            </editor>
                        </viewcolumn>
                    </viewheader>
                </gridview>
            </gridcell>
        </gridlayout>
</panel>

GIT force checkout overwrite local files

GIT force checkout overwrite local files

• reverting changes
• removing new files
• get latest from remote repository

git reset HEAD --hard

git clean -f -d

git pull origin master

PL/SQL calls REST webservice

PL/SQL calls REST webservice

Function f_rest_call( stringjson )

  req utl_http.req;

  res utl_http.resp;

  url varchar2(2000) := 'REST url';

  buffer varchar2(1000);

  content varchar2(4000) := stringjson ;

begin

  req := utl_http.begin_request(url, 'POST',' HTTP/1.1');

  utl_http.set_header(req, 'user-agent', 'mozilla/4.0');

  utl_http.set_header(req, 'content-type', 'application/json');

  utl_http.set_header(req, 'Content-Length', length(content));

  utl_http.set_header(req, 'Authorization', 'Basic d124553rpwYXNzd29yZA=='); --It Uses Basic Authorization 

  ----//SYS.utl_http.write_raw(req, contentgetStringVal()); 

  utl_http.write_text(req, content);

  res := utl_http.get_response(req);

  begin

    loop

      utl_http.read_line(res, buffer);

     

    end loop;

    utl_http.end_response(res);

  exception

    when utl_http.end_of_body

    then

      utl_http.end_response(res);

  end;

end

*ERROR* User HRBATUSR not authorized access form in Banner 9

*ERROR* User HRBATUSR not authorized access form in Banner 9

ex:

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');

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