Granting Privileges On An Object May Cause Invalidations
Last updated on FEBRUARY 09, 2018
Applies to:Oracle E-Business Suite Technology Stack - Version 12.2.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Granting privileges on an object may cause object invalidations in the current edition.
Grants cannot be performed in the run edition when the application is being used. The requirement is to run an online patching whenever
granting privileges on objects in the APPS schema to other users. When grants are given to stub objects it invalidates all dependent stub objects. This
might not be acceptable for customers when the objects are being used by running Applications.
In 12.2 When grants are given to "Stub objects" it invalidates all dependent stub objects. "stub objects" are simply pointers to an actual object definition from an ancestor edition that is still being inherited by the given edition.
ad_zd.grant_privs (created by patch 19674458:R12.AD.C) brings a new API for providing grants to objects with minimal invalidation.
Henceforth granting in 12.2 ; should be using only ad_zd.grant_privs instead of 'grant' (DDL) directly
SQL> grant select on FND_CONCURRENT_REQUESTS TO apps;
X_PERMISSIONS in varchar2, /* comma-seperated permission list */
X_OBJECT_NAME in varchar2, /* name of APPS object or APPS synonym */
X_GRANTEE in varchar2, /* grantee schema or role */
X_OPTIONS in varchar2 default NULL); /* grant options, example: 'WITH
GRANT OPTION' */
exec AD_ZD.grant_privs('SELECT', 'FND_RESPONSIBILITY', 'MSC',X_GRANT_TO_TABLE=>TRUE)
PL/SQL procedure successfully completed.
SQL> exec AD_ZD.revoke_privs('SELECT','FND_RESPONSIBILITY','MSC');
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms