Problem logging on to DB2 v9 with non-admin rights

Rudolf Bargholz

Windows 2003 R2 Server
DB2 Express C Version 9

DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL09012" with
level identifier "01030107".
Informational tokens are "DB2 v9.1.200.166", "special_17369",
"WR21380_17369",
and Fix Pack "2".

DB2 is installed on the server and a database has been created. I am
able to log on to the database using the db2admin user or any other
administrator on the server locally using

First open the db2cmd.exe, then issue a
db2 connect to MYDB user db2admin using mypassword

successfully. As soon as I switch to a user that has simple user
rights, or is a power user and issue a connect nothing happens:

C:\>db2 connect to MYDB user db2admin using mypassword

C:\>db2 connect to MYDB user db2admin using mypassword

No error is reported in the db2cmd window. No error is reported in the
Windows error log. No error is reported in the db2diag.log. The
connect is issued in a terminal window on the same server with a non-
admin user logged on.

Client and Server are on the same machine. I have tested using the
LOCAL connection as well as a TCP/IP connection from the client to the
server.

Does anyone have any idea what could be wrong here?
Do I have to give the normal user accounts any special rights for
these to use the DB2 CLI interface? I have never had a similar problem
in previous installations of DB2 v9 clients.

Note, I am able to open the db2cmd.exe with a user with non-admin
rights. As a test I have set up the SQLLIB directory so that all users
have all rights on this directory, this did not resolve my problem.

Regards

Rudolf Bargholz

Oct 12 '07 #1

Subscribe Reply

2834

Jurgen Haan

Hi Rudolf.

It might be that the admin users that you are referring to, are the
users that belong the the group defined in the DBM as SYSADM_GROUP
members. They generally bypass all database level restrictions. Meaning
they can access objects they do not have the explicit access to.
For any other user, the permissions have to be granted.
Check which group defines your non-admin users as users able to use the
database and check if they have CONNECT permissions to start with. If
so, check if they have permission to use anything at all.
If not, log in as an admin the perform the necessary grants.

I hope this helps a bit.

Regards,

-R-
Rudolf Bargholz wrote:

Does anyone have any idea what could be wrong here?
Do I have to give the normal user accounts any special rights for
these to use the DB2 CLI interface? I have never had a similar problem
in previous installations of DB2 v9 clients.

Regards

Rudolf Bargholz

Oct 12 '07 #2

Rudolf Bargholz

Hi Jurgen,

Thanks for the advice. Turns out the solution was to add all the users
that were logging on to the terminal server without admin right to the
DB2USERS group. After adding the users to the DB2USERS group the
connect funtionen correctly.

Regards

Rudolf Bargholz

Oct 12 '07 #3

Similar topics

2954

Logging messages with dictionary args in Python 2.4b1 leads to exception

by: Stefan Behnel | last post by:

Hi! I'm trying to do this in Py2.4b1: ------------------------------- import logging values = {'test':'bla'} logging.log(logging.FATAL, 'Test is %(test)s', values)...

Python

1825

switch query logging while the server is running

by: Christian.Gruber | last post by:

>Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses...

MySQL Database

2303

memory allocation logging for leak detection - problem with globals

by: Spur | last post by:

Hi all, I implemented a memory allocation/deallocation class that logs all new/delete calls (overloaded) and remembers for each allocated block where it was allocated from (using a macro that...

C / C++

2185

improvements for the logging package

by: Rotem | last post by:

Hi, while working on something in my current project I have made several improvements to the logging package in Python, two of them are worth mentioning: 1. addition of a logging record field...

Python

2449

NTEventLogHandler not logging `info'?

by: Jaime Wyant | last post by:

This code doesn't seem to do what I think it should do: # python 2.3.2 # not sure of my win32 extensions version import logging from logging.handlers import NTEventLogHandler logger =...

Python

1836

__builtins__.loglog - logging more pythonic, decent & scalable ?

by: robert | last post by:

As more and more python packages are starting to use the bloomy (Java-ish) 'logging' module in a mood of responsibility and as I am not overly happy with the current "thickener" style of usage, I...

Python

8531

logging error with RotatingFileHandler

by: flupke | last post by:

Hi, i'm getting errors with the log module concerning RotatingFileHandler. I'm using Python 2.4.3 on Windows XP SP2. This used to work in previous python versions but since i upgraded to 2.4.3...

Python

5381

RotatingFileHandler bugs/errors and a general logging question.

by: nicholas.petrella | last post by:

I am currently trying to use the python logging system as a core enterprise level logging solution for our development and production environments. The rotating file handler seems to be what I...

Python

6382

Custom log handler and logging.config.fileConfig()

by: Lowell Alleman | last post by:

Here is the situation: I wrote my own log handler class (derived from logging.Handler) and I want to be able to use it from a logging config file, that is, a config file loaded with the...

Python

1141

Exception Handling Problem

by: stephen | last post by:

Hi, I am a lil confused about exception handling. I have a main app and i am importing 2 DLL's. one of the DLL's is for connection/datasets etc and the other has logging errors to file.Both...

ASP.NET

7192

What is ONU?

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,...

General

7064

Changing the language in Windows 10

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

Windows Server

7315

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

7445

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5559

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4665

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3158

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

721

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

369

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General