Wednesday, 11 August 2021

EBS R12.2 Granting privileges on an object may cause object invalidation's in the current edition(Use AD_ZD.GRANT_PRIVS Only)

 To Grant:

SQL> exec AD_ZD.grant_privs('SELECT', 'FND_USER', 'XXUSER');


PL/SQL procedure successfully completed.


To Revoke:


SQL> exec AD_ZD.revoke_privs('SELECT', 'FND_USER', 'XXUSER');

No comments:

Post a Comment

Number of Visitors