APPLSYSPUB schema

APPLSYSPUB  is the database schema. it is the first schema which is used in any connection in Oracle apps.

Oracle forms, oacore  all connects to it first

The APPLSYSPUB account should have only these grants –
INSERT ON FND_UNSUCCESSFUL_LOGINS
INSERT ON FND_SESSIONS
EXECUTE ON FND_DISCONNECTED
EXECUTE ON FND_MESSAGE
EXECUTE ON FND_PUB_MESSAGE
EXECUTE ON FND_SECURITY_PKG
EXECUTE ON FND_SIGNON
EXECUTE ON FND_WEBFILEPUB
SELECT ON FND_APPLICATION
SELECT ON FND_APPLICATION_TL
SELECT ON FND_APPLICATION_VL
SELECT ON FND_LANGUAGES_TL
SELECT ON FND_LANGUAGES_VL
SELECT ON FND_LOOKUPS
SELECT ON FND_PRODUCT_GROUPS
SELECT ON FND_PRODUCT_INSTALLATIONS
These permissions are set in –
/admin/sql/afpub.sql
To check permissions

SELECT * FROM sys.dba_tab_privs
where grantee = ‘APPLSYSPUB’

 

How to change password for APPLSYSPUB

Change the password using FNDCPASS utility and then update the context file with it and run autoconfig

Related Articles

Guest User password in 11i/R12

FNDCPASS and AFPASSWD

How to resolve the ORA-01017: invalid username/password; logon denied

Changing the Oracle WebLogic Server Administration User Password in R12.2

Steps to change Admin Password which is lost or forgetten of an EBS WebLogic Domain R12.2

Leave a Reply