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: