473,385 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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 1389
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Ping | last post by:
Hello, Have a wonderful new year! I have oracle 9.2 on XP. There is a table T1 created by user U1 in U1's schema, a synonym S1 created also by U1 to point to T1 in U1's schema, U1 granted...
0
by: Chris Callahan | last post by:
Greetings: Long time reader, first time poster. Here we go: ==Specific question: Does there exist in MySQL a privilege configuration which will allow an account to issue `SHOW MASTER...
0
by: Christophe Poirier | last post by:
------=_NextPart_000_0023_01C35B54.206CFD60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am working on a Windows 2000 server. The version 4.0.13 was...
0
by: Fei Peng | last post by:
>Description: High Resolution Science Imaging experiment(HiRISE) project for one of important instrument on MRO spacecraft which will be launched to MAR in 2005 are using MySQL server 4.0.13 as...
1
by: José Joye | last post by:
I know, this kind of question has already been asked. However, I could not find an answer related to the minimal privilege required to be able to create a new event Source in the appplication event...
4
by: Sergey Suleymanov | last post by:
Documentation says "By default, only the owner (creator) of the function has the right to execute it." But for me newly created function has execute privilege to public by default. And we have...
2
by: Praveen_db2 | last post by:
Hi All I need to give authrization/Privilege for a user such that he should be able to run stored procedures but cannot change its code i.e he should not be able to compile it.I looked in the...
7
by: Parv | last post by:
I am impersoanting a user to an other domain. But while doing so i am getting A required privilege is not held by the client exception. I have tried with aal possible usernames and passwords...
1
by: jatinder.saundh | last post by:
Hi, How do I give create database privielege to a specific user/group at a particular db2 instance ? I read about various authorities like SYSCTRL etc. but I am interested in giving only Create...
1
by: Laurence | last post by:
Hi folks, In the middle of page 231 on the book "Administration Guide - Implementation" stated - "In addition to these package privileges, the BINDADD database privilege allows users to create...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.