Minimum privileges for Oracle database.

book

Article ID: 158481

calendar_today

Updated On:

Products

Mobility Suite

Issue/Introduction

Minimum privileges for Oracle 11g database.

 No error messages are displayed.

Cause

General Information on Server to Database permissions.

Resolution

We have received official approval on the following privileges for Oracle with Mobility Suite.

They are as follows:

Privileges:
CREATE SESSION
CREATE TABLE
CREATE SEQUENCES
CREATE TRIGGERS

Quota:
UNLIMITED (or appropriate per DBA)

Please note that additional privileges may be required depending on how the database is configured. Privileges such as extending the tablespace.

 

Applies To

 

Mobility Suite 5.5+ connecting to Oracle 11g

RHEL/CentOS 6.6