Additional Information

This section describes the additional information related to Oracle E-Business Suite.

Support for AD_ZD.GRANT_PRIVS Package

The SailPoint Oracle E-Business Suite Connector supports the service account permissions provided through the AD_ZD.GRANT_PRIVS API from Oracle E-Business Suite version 12.2.4 and later.

The following is the syntax for granting permissions through AD_ZD.GRANT_PRIVS:

EXECUTE APPS.AD_ZD.GRANT_PRIVS( X_PERMISSIONS in VARCHAR2, X_OBJECT_NAME in VARCHAR2,X_GRANTEE in VARCHAR2, X_OPTIONS in VARCHAR2 default NULL);

For example,

EXECUTE APPS.AD_ZD.GRANT_PRIVS('SELECT','FND_USER','<some role>');

This is equivalent to grant select on APPS.FND_USER to ${some role}; provided in Administrator Permissions.

Note

The following permissions cannot be granted through the AD_ZD.GRANT_PRIVS API as the objects mentioned are owned by the SYSTEM:

grant select on SYS.DBA_USERS to ${new role};
grant select on DUAL to ${new role};

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.