By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

privilege issues

P: n/a
When I try to drop a database or list the applications, I get the following
error:

SQL1092N: dbsys does not have the authority to perform this command.

I checked:

db2 get dbm cfg|grep SYSADM_GROUP and I got the o/p as SYSAMIN group.

I (dbsys) is part of the SYSADMIN group.

I am looking for some suggestions on what I should try next?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jani Tamminen wrote:
When I try to drop a database or list the applications, I get the
following error:

SQL1092N: dbsys does not have the authority to perform this command.

I checked:

db2 get dbm cfg|grep SYSADM_GROUP and I got the o/p as SYSAMIN group.

I (dbsys) is part of the SYSADMIN group.

I am looking for some suggestions on what I should try next?


Connect to the database as user DBSYS and run GET AUTHORIZATIONS. If it
doesn't show up there that you have SYSADM privileges, then something
doesn't match as it should.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.