Oracle Exam 1Z0-920 Topic 7 Question 18 Discussion

Actual exam question for Oracle's 1Z0-920 exam

Question #: 18
Topic #: 7

[All 1Z0-920 Questions]

How would you restrict a user Joe from accessing all MySQL database objects?

ACREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

BREVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

CUPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

DInsert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

ECREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

Show Suggested Answer

Suggested Answer: D

by Pete at May 03, 2022, 10:50 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!