469,336 Members | 5,570 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

privilege issues

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
1 1289
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.

Similar topics

reply views Thread by Chris Callahan | last post: by
reply views Thread by Christophe Poirier | last post: by
reply views Thread by Fei Peng | last post: by
4 posts views Thread by Sergey Suleymanov | last post: by
2 posts views Thread by Praveen_db2 | last post: by
1 post views Thread by jatinder.saundh | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.