Examine Joe's account:CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'GRANT ALL PRIVILEGES ON *.

Oracle 1z0-908 Question Answer

Examine Joe's account:

CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'

GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'

All existing connections for joe are killed.

Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

ALTER USER 'joe'@'%' ACCOUNT LOCK

ALTER USER 'joe'@'%' SET password='*invalid*'

REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

ALTER USER 'joe'@'%' PASSWORD HISTORY 0

ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

REVOKE USAGE ON *.* FROM 'joe'@'%'

1z0-908 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"

Examine Joe's account:CREATE USER 'joe'@'%' IDENTIFIED BY 'secret'GRANT ALL PRIVILEGES ON *.