472,984 Members | 2,053 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Allow DB2 acces through db2connect only from delimited clients

Hello,
I would like to known if it is possible to limit acces to a UDB
database on Solaris system through db2connect to only specified
clients ?
My client is a db2connect on Windows platform.

Thank you
Nov 12 '05 #1
4 2728
You can limit access to DB2 UDB on a Solaris server through use of the
os level userid/password definitions (etc/passwd) or via internal DB2
object-level and priviledge security. That limitation would be done via
userid/group .... I don't believe you can limit that access to specific
client machines from DB2.

By the way, you should be using a DB2 client to communicate directly
with the DB2 server on Solaris. DB2 Connect is only required to connect
to DB2 on the mainframe or AS/400.

Larry Edelstein

Kona wrote:
Hello,
I would like to known if it is possible to limit acces to a UDB
database on Solaris system through db2connect to only specified
clients ?
My client is a db2connect on Windows platform.

Thank you


Nov 12 '05 #2
I'm not sure if I understood your question correctly.

First of all you don't need DB2 Connect to connect a Win Client to a
Solaris box. All you need is a Db2 Runtime Client for Windows and the
correct database and node directory entries to address your database
on Solaris. If you want to limit access to specific users, you only
have to create those users as local users on your solaris box and set
DB2 DBM CFG parameter AUTHENTICATION to SERVER (which btw is the
default).

HTH
Joachim

ko*******@yahoo.fr (Kona) wrote in message news:<a1**************************@posting.google. com>...
Hello,
I would like to known if it is possible to limit acces to a UDB
database on Solaris system through db2connect to only specified
clients ?
My client is a db2connect on Windows platform.

Thank you

Nov 12 '05 #3
Sorry, my question was certainly not so clear.
My clients (Windows) are using an application that communicate via
ODBC to the UDB DB on Sun Solaris (Unix plateform).
We are using ODBC over a DB2Connect.
A db2Connect gateway server is using between the client and the UDB
server. So normally all request to the UDB are coming from the
db2Connect gateway.

The AUTHENTICATION parameter is already set to SERVER and local users
accounts are created onto the nix server. Each Unix group account are
granted to the UDB database.

Now all the security acces is set by the client application.
Suppose that someone can use the ODBC connection from MSQUERY, and now
is able to access the UDB tables without restriction (that normaly set
by the application).

So I would like to force that all request are coming only from the
db2connect gateway.

I do not known if now is a little more clear.

Thank you

Jo*******@email.com (Joachim Klassen) wrote in message news:<b5**************************@posting.google. com>...
I'm not sure if I understood your question correctly.

First of all you don't need DB2 Connect to connect a Win Client to a
Solaris box. All you need is a Db2 Runtime Client for Windows and the
correct database and node directory entries to address your database
on Solaris. If you want to limit access to specific users, you only
have to create those users as local users on your solaris box and set
DB2 DBM CFG parameter AUTHENTICATION to SERVER (which btw is the
default).

HTH
Joachim

ko*******@yahoo.fr (Kona) wrote in message news:<a1**************************@posting.google. com>...
Hello,
I would like to known if it is possible to limit acces to a UDB
database on Solaris system through db2connect to only specified
clients ?
My client is a db2connect on Windows platform.

Thank you

Nov 12 '05 #4
Sorry, my question was certainly not so clear.
My clients (Windows) are using an application that communicate via
ODBC to the UDB DB on Sun Solaris (Unix plateform).
We are using ODBC over a DB2Connect.
A db2Connect gateway server is using between the client and the UDB
server. So normally all request to the UDB are coming from the
db2Connect gateway.

The AUTHENTICATION parameter is already set to SERVER and local users
accounts are created onto the nix server. Each Unix group account are
granted to the UDB database.

Now all the security acces is set by the client application.
Suppose that someone can use the ODBC connection from MSQUERY, and now
is able to access the UDB tables without restriction (that normaly set
by the application).

So I would like to force that all request are coming only from the
db2connect gateway.

I do not known if now is a little more clear.

Thank you

Jo*******@email.com (Joachim Klassen) wrote in message news:<b5**************************@posting.google. com>...
I'm not sure if I understood your question correctly.

First of all you don't need DB2 Connect to connect a Win Client to a
Solaris box. All you need is a Db2 Runtime Client for Windows and the
correct database and node directory entries to address your database
on Solaris. If you want to limit access to specific users, you only
have to create those users as local users on your solaris box and set
DB2 DBM CFG parameter AUTHENTICATION to SERVER (which btw is the
default).

HTH
Joachim

ko*******@yahoo.fr (Kona) wrote in message news:<a1**************************@posting.google. com>...
Hello,
I would like to known if it is possible to limit acces to a UDB
database on Solaris system through db2connect to only specified
clients ?
My client is a db2connect on Windows platform.

Thank you

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Google Mike | last post by:
I've got RH9 Linux with default PHP. Is there a way to send email on Linux to an Exchange Server from PHP and/or other tools when there is *NOT* SMTP access? Has anyone figured out a way to...
2
by: Evelyn Schwartz via SQLMonster.com | last post by:
use this-is-a-stupid-name returns an error For that matter select * from this-is-a-stupid-name.dbo.anytable returns an error
3
by: Kona | last post by:
Hello, Do I need db2connect to connect an ODBC client application (Windows) to a DB2 database on a Unix platform (SUN) ?
0
by: Andreas Schmied | last post by:
Hello, I have a probleme with the db2connect, hope someone can help me. A Javaprogramm connect to the db2 with db2connect and the ibm db2class. Now i need to check if the pw is expired or not,...
1
by: lfo | last post by:
Hello, I use the db2connect of Aix 5.2 to communicate with AS/400 and I have the error message common_communication sqlcctcpconnr Probe:110 DIA3202C The TCP/IP call "connect" returned an...
3
by: updates4004 | last post by:
Hello all! Does anybody use DB2Connect on United Linux 1.0 We have the following Problem: The DB2Connect Software enables access from DB2 Clients (e.g. for connecting Application Servers to...
2
by: Valentin via DBMonster.com | last post by:
Hello, this is my db2icrt.log.xxxxx: ------------------------------------------------------ Program name = db2idbm Instance home dir = /home/db2inst1, Sysadm group = db2iadm1 Instance type =...
0
by: anokun7 | last post by:
We are using DB2 v7 on OS/390. I have installed db2connect enterprise on my local windows XP box. Using db2connect I have created a dsn and could successfully connect using the DB2 control...
0
by: MAHALINGAMJ | last post by:
My stored proc in DB2 version 9 is failing to return CURSOR. I am using DB2connect. Would appreciate any help on this. CLI window error: db2 => call TST_SCH.PR_TST_RETURN_CURSOR(1) SQL1224N ...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.