By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Create DB2 USERS and Connect

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
Hi,
Hope this helps,

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

Regrads,
Kiran Nair

Apr 24 '06 #4

P: n/a
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

P: n/a
Thanks Kiran and mark..
~ Me

Apr 25 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.