Is It a Requirement to Grant Execute Permission on DBMS_SYSTEM and DBMS_CRYPTO Packages to All RMS Users?

(Doc ID 1633230.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0 and later
Information in this document applies to any platform.
Checked for relevance 14-Feb-2017


In Oracle Retail Merchandising System (RMS) Release 13.2 or higher:

RMS provides a script "STAGING_DIR/rms/dbschema/create_db/create_user_generic.sql" to create a generic user for RMS.  The script includes grant execute on DBMS_SYSTEM and DBMS_CRYPTO packages.

Is it a requirement to have the execute permission on DBMS_SYSTEM and DBMS_CRYPTO packages granted to all RMS users?



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