Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a
connection event that has used external authentication?
A.
The attribute “STATUS” is set to the string EXTERNAL_AUTH.
B.
The attribute “PRIV_USER” contains the username.
C.
The event type that is given in the attribute “NAME” is EXTERNAL_AUTH.
D.
There is no differentiation between native and external authentication events.
E.
External authentication is managed through external auditing logs.
F.
The “PROXY_PRIV” user shows a username if external authentication is used.
E
B.
Stupid question:
OS_LOGIN identifies EXTERNAL authentication.
https://dev.mysql.com/doc/refman/5.6/en/audit-log-file.html
If so, then E and D not true.
STATUS shows 0 or error number – so A not true
There are no “PROXY_PRIV” attribute – so F not true
for NAME The possible values are “Audit”, “Binlog Dump”, “Change user”, “Close stmt”, “Connect Out”, “Connect”, “Create DB”, “Daemon”, “Debug”, “Delayed insert”, “Drop DB”, “Execute”, “Fetch”, “Field List”, “Init DB”, “Kill”, “Long Data”, “NoAudit”, “Ping”, “Prepare”, “Processlist”, “Query”, “Quit”, “Refresh”, “Register Slave”, “Reset stmt”, “Set option”, “Shutdown”, “Sleep”, “Statistics”, “Table Dump”, “Time”. – so C not true (link the same. See above)
I don’t see contradiction in B.
May be this is true answer – but it’s not only for external authentication…
E
D