IBM Support

CTE0228 This user has insufficient access rights

Troubleshooting


Problem

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21634094