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

Goal

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?


 

Solution

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