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 > instance owner login

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-01-11, 20:31
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
instance owner login

How do you setup login for multiple DBA's supporting the same Linux/Unix environments?

Each DBA logon to the server with their personal id and then 'sudo su - <instance owner>'? Is there a better (more secure) way to accomplish this?
Reply With Quote
  #2 (permalink)  
Old 12-02-11, 04:46
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
We use ssh + Priv/Publ-Key.
It's not the safest way, but works good for us.
Reply With Quote
  #3 (permalink)  
Old 12-02-11, 05:30
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Alternate approach is to setup a group, say, db2sysg1 ,add the dba users (+ instance owner, of course) and assign SYSADM_GROUP to this group.

The DBAs can use their own logins to do remote administration (Datastudio,quest) and also use monitoring tools (like db2mon). This helps in auditing remote connections also.

Quote:
Originally Posted by db2girl View Post
How do you setup login for multiple DBA's supporting the same Linux/Unix environments?

Each DBA logon to the server with their personal id and then 'sudo su - <instance owner>'? Is there a better (more secure) way to accomplish this?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #4 (permalink)  
Old 12-02-11, 06:27
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
If every DBA administer db2 using their personal id (with SYSADM privilege), then there is a way to tell who had done what (ie. drop table) if db2audit is setup. If they "su" to the instance owner, then I think there is no way? "su" is logged, but everything else (db2 admin tasks) will be logged as the instance owner id and I will have no way of telling who had done what to the db?

How is this setup in most shops? What I'm after is a way of tracking down each DBA activity (just in case something goes wrong...)
Reply With Quote
  #5 (permalink)  
Old 12-02-11, 08:22
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by sathyaram_s View Post
Alternate approach is to setup a group, say, db2sysg1 ,add the dba users (+ instance owner, of course) and assign SYSADM_GROUP to this group.

The DBAs can use their own logins to do remote administration (Datastudio,quest) and also use monitoring tools (like db2mon). This helps in auditing remote connections also.
One thing I don't like about that is if there are multiple instances on the server, once you logon as instance owner, the correct DB2 profile is always invoked and you are always pointed to the correct instance.

Otherwise, if a personal id is used with SYSADM, some inadvertent mistakes could happen because the user may not realize which instance they are attached to.
__________________
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
  #6 (permalink)  
Old 12-02-11, 08:49
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Also keep in mind that when people create objects (tables, routines) under their own authorization IDs the objects will be owned by these different IDs, which causes confusion later (e.g. another DBA not being able to CREATE OR REPLACE or DROP objects) unless permissions are explicitly granted to the DBA group or individual IDs.
Reply With Quote
  #7 (permalink)  
Old 12-02-11, 09:35
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
It looks like using the instance owner id is easier to manage and can be less error prone, but I'm not sure how to track down who had been using this id to do db2 admin work other than to see when "su" was logged.
Reply With Quote
  #8 (permalink)  
Old 12-06-11, 23:17
wolaos123 wolaos123 is offline
Registered User
 
Join Date: Nov 2011
Location: Shen Zhen,China
Posts: 37
we are using the way like:

login the server with personal id,then "sudo su - inst",adding some script into the instance's .profile to record all the commands(even wrong commands) they used into a log file.
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