Which of the following authorities is sufficient for connecting to a database?
Which of the following authorities is sufficient for connecting to a database?
The authority required to connect to a database is the CONNECT authority. This permission explicitly allows the holder to connect to the database and perform basic read operations, making it fundamental for database connectivity purposes.
I think the correct answer is B which is the least needed to connect.
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
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
Why Ans B -> Connect is not wrong ?
SQLADM and DATAACCES authorities cannot grant / revoke connect. ACCESSCTRL can grant/revoke connect.