Question

The table that lists the column level privileges is _____________

(a) columns_priv

(b) db

(c) tables_priv

(d) procs_priv

The question was posed to me during an online interview.

My doubt is from External Security: Preventing Unauthorized Network Access in portion Access Control and Security of MySQL

Answer 1

Correct answer is (a) columns_priv

The explanation: The ‘columns_priv’ table lists the column-level privileges. A privilege that is supplied here applies to a particular column. The ‘db’ table lists which accounts have privileges for which databases.