SAP Knowledge Base Article - Preview

3639074 - could not drop USER id on DB2 database

Symptom

Sometime we could find the user in database with following command:

select * from SYSIBMADM.AUTHORIZATIONIDS

when we tried to drop the user with following command:

db2 connect to <SID>
db2 drop user <user name>

The following errors happens:

DB21034E The command was processed as an SQL statement because it was not
a valid command line processor command. During SAP processing it returned:
SQL0104N An unexpected token "user" was found following "drop ". Expected
token may include: "<program_or_package>"


Read more...

Keywords

db2 drop user, AUTHORIZATIONIDS , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.