The AD_ZD.GRANT_PRIVS procedure is meant to operate on EBS APPS logical objects, meaning the object present or exposed in the APPS schema and identified.
The AD_ZD.GRANT_PRIVS procedure is meant to operate on EBS APPS logical objects, meaning the object present or exposed in the APPS schema and identified by its name or synonym in the APPS schema. Such an object could be:, 1/22/2020 · 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, TESTING Performed in an Internal Instance===== EXECUTE apps.AD_ ZD.GRANT _PRIVS(‘select’,’FND_CONCURRENT_REQUESTS’,’PO’); SQL> EXECUTE apps.AD_ ZD.GRANT _PRIVS(‘select’,’FND_CONCURRENT_REQUESTS’,’PO’);PL/SQL procedure successfully completed.SQL> SHOW USERUSER is APPS 1* SELECT.
11/9/2017 · exec AD_ZD.GRANT_PRIVS ( X_PERMISSIONS , X_OBJECT_NAME, X_GRANTEE , X_OPTIONS, X_GRANT_TO_TABLE) X_PERMISSIONS:- refer to permissions to be granted like SELECT, INSERT, EXECUTE etc. X_OBJECT_NAME:- refers to the object name from APPS schema for which Grants would be given.
9/10/2018 · exec AD_ZD_TABLE.PATCH(‘XXCUST’,’XX_CUST_TBL1′) 3) Table grants must be done through API to avoid invalids. exec AD_ ZD.GRANT _PRIVS(‘SELECT’,’XX_CUST_TBL1′,’XX_ROLE0′) 4) To view objects in all editions..add _ae to the data dictionary views select * from user_objects_ae; 5) To update seed data tables in Patch edition, execute prepare command …
