Previous Topic: Upgrade OverviewNext Topic: Upgrading to Release 7.1.01


Database Privileges Required for Upgrade

The following table lists the database privileges that you must have for performing the database procedures related to upgrading to release 7.1.01:

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

 

To upgrade AuthMinder on Windows successfully, the account that you plan to use for upgrade must belong to the Administrators group.