If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Post Installation task of DB2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-11-04, 23:37
srihari_cit srihari_cit is offline
Registered User
 
Join Date: Apr 2004
Location: arlington,tx
Posts: 12
Post Installation task of DB2

Hai
I have installed db2 8.1 on linux machine. The current db2 users are instance user(db2inst1), fenced user(db2fenc1) and db2as(administration server). To start using the database do I have to create additional users or use the database as the instance owner itself.

1) How do I create db2 users and test a connection from a db2 user.

2) If I have to create a new user , to which group do I have to make him belong. I have three groups (db2iadm1 which has db2inst1, db2fadm1 which has db2fenc1 and db2asgrp which contains db2as)

Please clarify. thanks.
Reply With Quote
  #2 (permalink)  
Old 04-12-04, 02:30
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
You create users using the Linux OS facilitates to create users. They do not have to belong to any of the defined groups. You give authority to the user with the GRANT SQL command (see the SQL Reference for details) or use the GUI on the Control Center for some grants.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On