Retail Merchandising System (MOSC)

MOSC Banner

What are the minimum privileges required on RMS database user?

The RMS v12.1 Installation guide (appendix D - RMS user creation script) suggests the following DB/system privileges on generic (business) users :

grant developer, select_catalog_role,alter session,analyze any,create any synonym,create any type,create database link,create library,create procedure,create public database link,create public synonym,create sequence,create session,create synonym,create table,create trigger,create view,drop any synonym,execute any procedure,execute any type,select any sequence,select any table,select any dictionary,query rewrite,create materialized view,create any context to &schema_owner

The RMS v14.1 Installation guide refers to the create_user_generic.sql script for general (business) users, which grants the following privileges:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center