473,881 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Create DB2 USERS and Connect

Hi,

Y'day one of my friend showed me how to connect to a Oracle
database as
SYSDBA, DBA etc

I have DB2 UDB installed in Linux machine.Right now, I have a user WADI
which has got some previliges on the tables. But I dont know how to
connect as SYSDBA etc

Now, in Linux what are the steps to

1.) Create users with

a) SYSADM
b) DBADM
c) SYSCTRL
d) SYSMAINT

priveleges and then

2.)Connect to the database using the different Users

E.g. In Oracle at login we can give as

Connect as /sysdba

what is the equivalent in DB2 UDB ?
I usually give

connect to dbname user XXX using XXX to connect to a database.
what command should I give to connect to a databse as SYSADM,DBADM etc
???

Thanks in advance,
~rAinDeEr

Apr 24 '06 #1
5 6679
Unlike Oracle, DB2 does no user or group management; rather it relies upon
the operating system for these services, as it should. Nor does it it have
any "magic" userids with special privileges as such a concept would prevent
auditing.

Follow your normal Linux procedures for creating users (and groups). Within
DB2 you can then use GRANT to assign the rights and privileges you deem to
be necessary. As part of the DB2 installation you specified a bootstrap user
(instance owner).

To connect you can specify the userid (and password) on the CONNECT. A far
better approach is to connect as the logged on user - again, allowing the OS
to do all the work - preferably by configuring Kerberos for the single
signon. This approach also enables non-password based authentication - such
as smart cards, and improves auditability.

To connect as a SYSADM or whatever, either log on as a user with SYSADM and
use single signon into DB2, or (if secure authentication procedures are
unimportant to you) issue a CONNECT using a suitable user's name and
password.

"rAinDeEr" <ta**********@g mail.com> wrote in message
news:11******** **************@ y43g2000cwc.goo glegroups.com.. .
Hi,

Y'day one of my friend showed me how to connect to a Oracle
database as
SYSDBA, DBA etc

I have DB2 UDB installed in Linux machine.Right now, I have a user WADI
which has got some previliges on the tables. But I dont know how to
connect as SYSDBA etc

Now, in Linux what are the steps to

1.) Create users with

a) SYSADM
b) DBADM
c) SYSCTRL
d) SYSMAINT

priveleges and then

2.)Connect to the database using the different Users

E.g. In Oracle at login we can give as

Connect as /sysdba

what is the equivalent in DB2 UDB ?
I usually give

connect to dbname user XXX using XXX to connect to a database.
what command should I give to connect to a databse as SYSADM,DBADM etc
???

Thanks in advance,
~rAinDeEr

Apr 24 '06 #2
Thanks Mark,

I wanted to know whether what I have done is correct. As adviced by
you, I had created a group in the OS and given priveleges to the
group..

I connect to a database using the connect command..

Can you give me more info on this--->

A far better approach is to connect as the logged on user - again,
allowing the OS
to do all the work - preferably by configuring Kerberos for the single
signon

How can I configure the Kerberos and what are the parameters which are
of importance..

Thanks for the Info

Apr 24 '06 #3
Hi,
Hope this helps,

http://www-128.ibm.com/developerwork...le/dm-0603see/

Regrads,
Kiran Nair

Apr 24 '06 #4
Kiran's IBM reference is probably the best source of information for the
Linux aspects of Kerberos.

"rAinDeEr" <ta**********@g mail.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
Thanks Mark,

I wanted to know whether what I have done is correct. As adviced by
you, I had created a group in the OS and given priveleges to the
group..

I connect to a database using the connect command..

Can you give me more info on this--->

A far better approach is to connect as the logged on user - again,
allowing the OS
to do all the work - preferably by configuring Kerberos for the single
signon

How can I configure the Kerberos and what are the parameters which are
of importance..

Thanks for the Info

Apr 25 '06 #5
Thanks Kiran and mark..
~ Me

Apr 25 '06 #6

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

Similar topics

4
25397
by: Omar Vazquez | last post by:
i developed an app in V.B. now i am trying to connect to db2, i think before i must create a user in the database, i made it in the next way. in db2 control center user y groups add new i gave it all settings but from my app denies me the acces, i can acces with a ODBC and the user db2admin but i thing it's not right. thanks in advance.
4
3609
by: cmc | last post by:
Hi, I 'm new to DB2 (from Oracle background) and have some fundamental question. In Oracle, you create user account "within the database" to let user to logon to the database. There is no tie between the unix account (or other operating system) and the oracle user account - you can logon to the server machine dose not mean you can logon to the database implicitly. However, I notice that there is no account creation in DB2 v8 UDB...
7
2753
by: Reza | last post by:
Hello The project was working, where I had a domain user registered in the database as a user, and I used that user to connect the datebase. Everything was fine and it was working, then when I moved the project to the production servers - database server and web server. Following that all the users are failing to connct to database, getting this message "login failed for user 'username' I am getting the user with property identity and it...
2
2137
by: Markus Prediger | last post by:
Hi NG, I have an asp.net project that uses an vb6 com object for some database-manipulation (I cannot rewrite it in .net, sorry, its not my decision). I want it to be instanciated seperately for each session, so that three users can connect to three different databases. But I get crazy because: -With interop all users share one instance - pure chaos (the instance is
2
5792
by: Steegg | last post by:
I am a newcomer to using Python and Qt and the main problem that I have is the dearth of any example code or books describing the use of Python and Qt together. My current problem is that I want to create a custom cursor, from my understanding of it I need to create two "QBitmap"s, one of which will be the mask and then using these to create a "QCursor". I don't mine whether the "QBitmap"s are hardcoded in the source code or come from...
2
5365
by: Michael | last post by:
Hello, I've created an ASP web page where users in our organization can create Active Directory computer accounts. The web page is running on a Server 2003 SP1 IIS 6 installation. The Exchange System Manager is running on the web server and Exchange SP2 has been installed. The web page uses ADSI code to create a user, and then CDO code to create
5
4883
by: Michael | last post by:
Hello, I've created an ASP web page where users in our organization can create Active Directory computer accounts. The web page is running on a Server 2003 SP1 IIS 6 installation. The Exchange System Manager is running on the web server and Exchange SP2 has been installed. The IIS site is configured with Basic Authentication and users are prompted to enter their Active Directory credentials when connecting to the site.
14
6150
by: mistral | last post by:
Need php script to create mySQL database programmatically; since hosting configuration may not allow create database from script, script also need eliminate/rewrite all restrictions in appropriate places in that hosting.
7
1415
by: =?Utf-8?B?SnVzdGlu?= | last post by:
Hello Everyone: I am having the most bizarre problem with my asp.net web app...this is my first web app in asp.net and I inherited it from a programmer who quit...so, I am not completely familiar with all the ins and outs. The problem is that some machines can open my web app and some machines cannot...In fact, the server, which is hosting the app and has VS.Net installed, cannot access the app via the external IP address, but other...
0
9928
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, 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...
0
10718
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 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...
0
10401
tracyyun
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...
1
7953
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5781
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5977
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4196
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3225
bsmnconsultancy
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...

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.