Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu06:aufgaben:a02 [2024/10/29 12:34] – vdemir
+++ modul:m290:learningunits:lu06:aufgaben:a02 [2024/11/20 14:36] (aktuell) – cbolzern
@@ Zeile 6: / Zeile 6: @@
 ===== Requirements  =====
   * Work type: individual
-  * Timeframe: 10 Minutes
+  * Timeframe: 20 Minutes
   * Means of aid:
       * only teaching materials, no websearch, no use of ai.
@@ Zeile 26: / Zeile 26: @@
 ==== Task 2.1 ====
-**Create the User**: Create a user named //restrictedUser// with the password //SafePassword123// using the //mysql_native_password// plugin.
+**Create the User**: Create a user named //restrictedUser// with the password //SafePassword123// using the //caching_sha2_password// plugin.
-  CREATE USER 'restrictedUser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SafePassword123';
+  CREATE USER 'restrictedUser'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'SafePassword123';
 ==== Task 2.2 ====
@@ Zeile 43: / Zeile 43: @@
 ==== Task 2.4 ====
-**Rovoke Privileges**: To be certain that nothing unintended can happen revoke the CREATE, ALTER, and DROP privileges explicitly.
+**Revoke Privileges**: To be certain that nothing unintended can happen revoke the CREATE, ALTER, and DROP privileges explicitly.
   REVOKE CREATE, ALTER, DROP ON myDatabase.* FROM 'restrictedUser'@'localhost';
@@ Zeile 57: / Zeile 57: @@
 ==== Task 2.7 ====
-Finally, try to perform a CREATE TABLE or DROP TABLE operation. The attempt should result in a permission error als displayed in the image below.
+Finally, try to perform a CREATE TABLE or DROP TABLE operation. The attempt should result in a permission error as displayed in the image below.
 ==== Task 2.8 ====
-**Delete the User (optional)**: After testing, you can delete the user if they are no longer needed.
+**Delete the User (optional)**: After testing, you can delete the user if it is not needed anymore.
 ===== Solution =====