CTE0228 This user has insufficient access rights

Technote (troubleshooting)


Problem(Abstract)

The "db2text start" command returns the error message 'CTE0228 This user has insufficient access rights at the operating system level.'

Symptom

db2text start commands fails with error message CTE0228


Cause

DB2 Version 9.7 includes authorization changes that affect the scope and abilities of SYSADM, SECADM and DBADM authority levels

Diagnosing the problem

The "db2text start" command returns the error message 'CTE0228 This user has insufficient access rights at the operating system level.'

Resolving the problem


db2 connect to DATABASE_NAME
db2  GRANT DBADM  ON DATABASE TO USER DB2_INSTANCE_OWNER
db2  GRANT  DATAACCESS ON DATABASE TO USER DB2_INSTANCE_OWNER

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Extenders - Text Extender

Software version:

9.7, 9.8

Operating system(s):

AIX, Linux, Linux iSeries, Linux pSeries, Linux zSeries, Solaris, Windows

Software edition:

Advanced Enterprise Server, Enterprise Server, Express, Express-C, Personal, Workgroup Server

Reference #:

1634094

Modified date:

2013-07-18

Translate my page

Machine Translation

Content navigation