Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu06:aufgaben:a02 [2024/10/29 12:17] – [Task A2] 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 myAppDB.* TO 'restrictedUser'@'localhost';
+  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 myAppDB.* FROM 'restrictedUser'@'localhost';
+  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';
+==== 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 =====