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 > A question of DB2 Authentication

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-18-06, 03:28
huyuhui huyuhui is offline
Registered User
 
Join Date: Apr 2004
Posts: 22
A question of DB2 Authentication

Question
AUTHENTICATION=SERVER_ENCRYPT allows DB2 to encrypt which of the following?
A.data
B.userid
C.password
D.userid and password
Answer: D

I am confused why the correct answer is D. I think it would be C.
Who can give me any tips?
Thanks so much!
__________________
**************************************
Make progress everyday
Mail: hoo.jimmy@gmail.com
**************************************
Reply With Quote
  #2 (permalink)  
Old 09-18-06, 09:18
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
you are correct:

"SERVER_ENCRYPT

Authentication takes place on the server.
Passwords are encrypted at the client machine
before being sent to the server."

--Rahul Singh
Reply With Quote
  #3 (permalink)  
Old 09-19-06, 05:41
singhipst singhipst is offline
Registered User
 
Join Date: Jul 2006
Location: Bangalore
Posts: 57
Hi Rahul,

Answer D is correct becouse if "SERVER_ENCRIPT" then user name and password both are sent via network to server in incripted formate.

"If you want to protect the user ID and password from eavesdropping, use
authentication type SERVER_ENCRYPT so that both user ID and password are
encrypted."

Ref.
Page No. 27 of
Server Management: DB2 V8.1 Database Administration certification prep, Part 1 of 6

https://www14.software.ibm.com/webap...P=db2-cert7016
__________________
Ritesh Kumar Singh
IBM Certified DB2 DBA for LUW
**Knowledge Is Theft If Not Shared !!**
Reply With Quote
  #4 (permalink)  
Old 09-19-06, 05:58
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
please read page 6
DB2 9 Fundamentals exam 730 prep, Part 2ecurity
20 Jul 2006

some updation is needed for ibm tutorials
Reply With Quote
  #5 (permalink)  
Old 09-19-06, 06:40
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
from v8 info center : http://publib.boulder.ibm.com/infoce...79%70%74%22%20

If authentication is SERVER, the *user ID and password* are sent from the client to the server so that authentication can take place on the server. The value SERVER_ENCRYPT provides the *same behavior* as SERVER, except that any *passwords* sent over the network are encrypted.


--Rahul Singh
Reply With Quote
  #6 (permalink)  
Old 09-19-06, 09:46
singhipst singhipst is offline
Registered User
 
Join Date: Jul 2006
Location: Bangalore
Posts: 57
Yes on
According to
DB2 8.2 Fundamentals exam 700 prep, Part 2 Security
page no 7
And
DB2 9 Fundamentals exam 730 prep, Part 2 Security
page no 6
The Answer C is correct

But

According to
DB2 8.2 DBA exam 701 prep, Part 1 Server Managemant
page no 27
and
DB2 9 DBA exam 701 prep, Part 1 Server Managemant
page no 24

Answer D is correct i am confused
Any One Can Explain ??
Which One Is Correct ??
__________________
Ritesh Kumar Singh
IBM Certified DB2 DBA for LUW
**Knowledge Is Theft If Not Shared !!**
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