APPLSYSPUB is the database schema. it is the first schema which is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in FND_USER table in Oracle database of oracle applications
Oracle forms, OACORE all connects to it first then this schema has the sufficient privileges to authenticate the username and password and change the connection to the apps schema. This is a very important schema and Oracle recommended not to use mixed character for its password.
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
First stop the EBS services on all the nodes and then Change the password using FNDCPASS utility and then update the context file with it and run autoconfig
FNDCPASS apps/apps 0 Y system/manager ORACLE APPLSYSPUB <passwd>
In the CONTEXT file, we need to locate the autoconfig variable “s_gwyuid_pass” and set
it to the new password, then run AutoConfig in each application nodes.
Once the autoconfig is completed,please verify the password in $CONTEXT_FILE, $FND_SECURE/*dbc and then start the EBS services
I hope you like the post on APPLSYSPUB schema in Oracle EBS. This is an important schema and should not be disabled. If it get disables , Oracle EBS will stop working
Related Articles
Guest User password in 11i/R12
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