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
2  2842 
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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)
-------------------------------
|
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 foreign database access
libraries, this would be very helpful. One could switch on logging,
perform an activity, switch off logging, and look what has happened.
Otherwise, the server has to be restarted to change logging, which
is a bit annoying......
|
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 passes __FILE__
and __LINE__). On destruction, it reports all undeleted blocks
(memory leaks).
The class is implemented in a separate .h/.cpp pair, and should be
linked to
|
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 %(function)s, which results in
the name
of the entity which logged the record. My version even deduces the
class name in the case which the logger is a bound method, and assuming
the name of the "self" variable is indeed "self".
|
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 = logging.getLogger("testlogger")
handler = NTEventLogHandler("testlogger")
logger.addHandler(handler)
| | |
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 want to put
this comment and a alternative most simple default framework for
discussion.
Maybe there are more Python users which like to see that imported
(managed) logging issue more down-to-earth and flexible ? ...
Vinay Sajip wrote:
>...
|
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 i get these errors:
Traceback (most recent call last):
File "C:\Python24\lib\logging\handlers.py", line 71, in emit
if self.shouldRollover(record):
|
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 am looking for as I want
the ability to have control over the number and size of log files that
are written out for each of our tools. I have noticed a few problems
with this handler and wanted to post here to get your impressions and
possibly...
|
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
logging.config.fileConfig() function.
Let say my logging class is called "MyLogHandler" and it's in a module
called "mylogmodule", I want to be able to make an entry something
like this in my logging config file:
|
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 DLL's have try{} catch(exception
ex){throw ex; } and i am force feeding errors so that I can catch the
exceptions.
I have done this:
1. for DLL1 (Logging Errors), I am force feeding (5/0) and it throws
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
