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 |