ExamTopics Logo
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-616 All Questions

View all questions & answers for the C2090-616 exam
Go to Exam

Exam C2090-616 topic 1 question 24 discussion

Actual exam question from IBM's C2090-616
Question #: 24
Topic #: 1
[All C2090-616 Questions]

Which of the following authorities is sufficient for connecting to a database?

  • A. SQLADM
  • B. CONNECT
  • C. DATAACESS
  • D. ACCESSCTRL
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21427232
by db2tester at Oct. 11, 2019, 1:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Belusa_7
4 years, 7 months ago
B is correct. ACCESSCTRL Allows the holder to grant and revoke all object privileges and database authorities except for privileges on the audit routines, and ACCESSCTRL, DATAACCESS, DBADM, and SECADM authority. CONNECT Allows the holder to connect to the database. https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005524.html
upvoted 1 times
...
ananthanarayanante
4 years, 10 months ago
I think the correct answer is B which is the least needed to connect.
upvoted 2 times
...
Devesh
5 years, 3 months ago
Why Ans B is not correct ? CONNECT Allows the holder to connect to the database. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005524.html
upvoted 1 times
...
Devesh
5 years, 3 months ago
Why Ans B -> Connect is not wrong ?
upvoted 1 times
...
db2tester
5 years, 6 months ago
SQLADM and DATAACCES authorities cannot grant / revoke connect. ACCESSCTRL can grant/revoke connect.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago