APPLSYSPUB schema



Last updated on November 28th, 2015 at 12:21 pm

APPSYSPUB  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


Leave a Reply