473,380 Members | 1,395 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,380 software developers and data experts.

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 6592
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**********@gmail.com> wrote in message
news:11**********************@y43g2000cwc.googlegr oups.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**********@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.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
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...
4
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...
7
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...
2
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...
2
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...
2
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...
5
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...
14
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...
7
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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?

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.