VERIFIED SOLUTION i
X

Roles/privileges required for Sagent repository hosted on Oracle

UPDATED: October 17, 2018


With Sagent repository hosted on Oracle, user needs to have minimum CONNECT and RESOURCE role rights and have at least 40MB of tablespace allocated.

Run the following query to get the privileges required:
​​​​​​select PRIVILEGE from role_sys_privs where role in ('CONNECT', 'RESOURCE');

This query produces following results:
PRIVILEGE 
------------- 
SET CONTAINER 
CREATE SEQUENCE 
CREATE TRIGGER 
CREATE CLUSTER 
CREATE PROCEDURE 
CREATE TYPE 
CREATE SESSION 
CREATE OPERATOR 
CREATE TABLE 
CREATE INDEXTYPE
----------------
10 rows selected 
Out of these 10 privileges, following privileges are mandatory while others mentioned can be provided on requirement basis:
  • CREATE SESSION 
  • CREATE TABLE 
  • Minimum 40 MB of Tablespace 
For example, in the case of the CONTAINER database is used for Oracle 12c, the repository user needs to have 'SET CONTAINER' privilege. 'SET CONTAINER' privilege is present from Oracle 12c.

Environment Details

Product Feature: Repository
Database: Oracle

Downloads

  • No Downloads