Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu06:aufgaben:a02 [2024/10/29 12:20] – [Tasc A5] 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 25: / Zeile 25: @@
   - Drop the newly created user finally
-==== Task A1 ====
+==== 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 A2 ====
+==== Task 2.2 ====
 ** Overview of the current privileges**: Display all users.
@@ Zeile 37: / Zeile 37: @@
 The result set should look like:
-{{:modul:m290:learningunits:lu06:aufgaben:a2.png?600|}}
+==== Task 2.3 ====
-==== Task A3 ====
 **Grant Privileges Without Table Management**: Grant the user //restrictedUser// the ability to read and write data but not to create, alter, or drop tables. Use the following commands to give only the required privileges.
   GRANT SELECT, INSERT, UPDATE, DELETE ON myDatabase.* TO 'restrictedUser'@'localhost';
-==== Task A4 ====
+==== 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';
-==== Tasc A5 ====
+==== Tasc 2.5 ====
 **View the User’s Privileges**: Check the privileges to ensure that the user cannot manage tables.
   SHOW GRANTS FOR 'restrictedUser'@'localhost';
-{{:modul:m290:learningunits:lu06:aufgaben:a3.png?800|}}
+==== Task 2.6 ====
+**Test the User’s Access**: Establish a new console connection to the database by using //restrictedUser + password//.
+==== Task 2.7 ====
-==== Task A6 ====
+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.
-**Test the User’s Access**: Connect as //restrictedUser// and try to perform a CREATE TABLE or DROP TABLE operation. The attempt should result in a permission error.
-==== Task A7 ====
+==== 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 =====