View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 06:49 AM
rAinDeEr
 
Posts: n/a
Default 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

Reply With Quote