5 Replies Latest reply: Aug 17, 2013 4:34 AM by HakanBiroglu RSS

    Installed FSCM 9.2 Demo w/ tools 8.53 on OEL 6, Oracle DB, Booted Web/App/Prcs ok, but error "Authorization Error -- Contact your Security AdministratorAuthorization" on page

    User569373-OC

      Installed FSCM 9.2 Demo w/ tools 8.53 on OEL 6, Oracle DB, Booted Web/App/Prcs ok, but error "Authorization Error -- Contact your Security Administrator" on page. Has anyone encounter this issue. I have done most of the usual troubleshooting already.

        • 1. Re: Installed FSCM 9.2 Demo w/ tools 8.53 on OEL 6, Oracle DB, Booted Web/App/Prcs ok, but error "Authorization Error -- Contact your Security AdministratorAuthorization" on page
          HakanBiroglu

          With which user are you logging in? VP1?

          Sounds like the user is missing Portal weblibs.

          Or try running Portal Security Sync process and clear local browser cache and try again.

          Running in trace mode will provide the missing elements in the application server log.

          • 2. Re: Installed FSCM 9.2 Demo w/ tools 8.53 on OEL 6, Oracle DB, Booted Web/App/Prcs ok, but error "Authorization Error -- Contact your Security AdministratorAuthorization" on page
            User569373-OC

            I'm using the VP1 account to login. Unfortunately, I do not have 2-tier access as i have to do everything on the server. All i got is Linux host and i can fix things from sqlplus on server. Can you let me know if there is a table i can update for a Permission list so VP1 gets the WebLibs. VP1 seems to have "PeopleTools" and "Peoplesoft User" roles, but i will make sure he has the required WebLibs. Thank you for your response.

            • 3. Re: Installed FSCM 9.2 Demo w/ tools 8.53 on OEL 6, Oracle DB, Booted Web/App/Prcs ok, but error "Authorization Error -- Contact your Security AdministratorAuthorization" on page
              HakanBiroglu

              Hi,

               

              Roles linked to users are stored table psroleuser.

              When I run following sql statement in my FSCM 9.2 demo env for user VP1, it returns 95 roles.

               

              select * from psroleuser where roleuser = 'VP1';

               

              And my environment is a ootb demo installation.

               

              Here is an export of my config that you can try to load in your env, but something has definitely gone wrong for your env.

              For a list of PeopleTools Security tables have a look at following blog

              PeopleTools Security - PeopleSoft Wiki

               

              REM INSERTING into psroleuser

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ADS Designer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTF Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTF Editor','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTF User','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Search Query Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PeopleTools','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Catalog Partner','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CC_ADMINISTRATOR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CC_USER_PO','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CC_USER_REQ','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CLAIMS_MGR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CLERK','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','XMLP Power User','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','VMI Manager','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','XMLP Report Developer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_EXPENSE_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_INV_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EOEN_USER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ePro Buyer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ePro Admin','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Search Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Search Developer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Search Server','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','IT Asset Manager','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ITEMLOAD_CONTACT','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','MANAGER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PAPP_USER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PBM User','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PeopleSoft User','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EMPLOYEE','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Employee North America','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Ent Utilities Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EOPP_USER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Event Buyer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Event Seller','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Forecaster','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Grants Super User','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EX_EMPLOYEE','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','MIN Adminstrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Connected Queries Developer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PeopleSoft Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Integration Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Supplier Contract Interested','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Supplier-Application Admin','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','UPG_ALLPNLS','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','UPG_APPSRVR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','VICE PRESIDENT','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','System Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Treasurer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EOTF_ADMIN','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ProcessSchedulerAdmin','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Project Owner','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Grants Workflow By Pass','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Inventory Policy Planner','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','CONSUMER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','DEALING MANAGER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PivotGridAdmin','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTLT_IMPLEMENTER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTLT_INTERNAL_APPS','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Translation Utilities','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ADMINISTRATOR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','AM_SS_ACCOUNTING_CLERK','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','PTLT_PROJECT_MGR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','RE_ADMIN','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Security Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SETTLEMENT_MGR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_ADMINISTRATOR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_COORDINATOR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_EXECUTIVE','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','RE_SUPER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','EOTL_Admin','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_INVOICE_MANAGER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_PLOG_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_PROVIDER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_PROVIDER_CONTACT','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_REQUESTER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_TIME_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SP_WO_APPROVER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','SUPERVISOR','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Supplier Contrct Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Demand Planner','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Employee','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Plan Approver','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Portal Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','ReportSuperUser','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','AM_SS_MANAGER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','App Developer','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','BAM Administrator','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','BANK MANAGER','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Budget Approver','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Call Center Agent','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Call Center Specialist','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Cash Manager','N');

              Insert into psroleuser (ROLEUSER,ROLENAME,DYNAMIC_SW) values ('VP1','Catalog Administrator','N');