Previous Topic: Versions That You Can Upgrade FromNext Topic: How to Upgrade CA Strong Authentication on Windows


Database Privileges Required for Upgrade

The following table lists the database privileges that you must perform related to the upgrade:

Database Type

Upgrade Privileges

Run time Privileges

Oracle

CREATE TABLE

CREATE TABLE

CREATE ANY INDEX

DML Privileges

CREATE ANY SEQUENCE

 

CREATE TABLESPACE (for Reports)

 

CREATE PROCEDURE

 

UNLIMITED TABLESPACE (for Reports, optional)

 

DROP TABLESPACE

 

ALTER ANY TABLE

 

ALTER TABLESPACE

 

DML Privileges (including

CREATE SESSION privilege)

 

MS SQL Server

Note: The UserID must also have the Database role of ddladmin.

CREATE TABLE

CREATE TABLE

CREATE INDEX

DML Privileges

CREATE PROCEDURE

 

EXECUTE PROCEDURE

 

REFERENCES

 

ALTER TABLE

 

DML Privileges

 

IBM DB2

CREATE TABLE

CREATE TABLE

CREATE INDEX

DML Privileges

CREATE SEQUENCE

 

CREATE TABLESPACE

 

CREATE TABLESPACE with AUTORESIZE = yes (for Reports, optional)

 

CREATE PROCEDURE (SQL - native)

 

ALTER TABLE

 

DML Privileges