modul:m290:learningunits:lu06:aufgaben:a02

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu06:aufgaben:a02 [2024/10/29 12:31] – vdemirmodul:m290:learningunits:lu06:aufgaben:a02 [2024/11/20 14:36] (aktuell) – cbolzern
Zeile 6: Zeile 6:
 ===== Requirements  ===== ===== Requirements  =====
   * Work type: individual   * Work type: individual
-  * Timeframe: 10 Minutes+  * Timeframe: 20 Minutes
   * Means of aid:    * Means of aid: 
       * only teaching materials, no websearch, no use of ai.       * only teaching materials, no websearch, no use of ai.
Zeile 26: Zeile 26:
  
 ==== Task 2.1 ==== ==== 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 ==== ==== Task 2.2 ====
Zeile 36: Zeile 36:
  
 The result set should look like: The result set should look like:
- 
-{{:modul:m290:learningunits:lu06:aufgaben:a2.png?800|}} 
  
 ==== Task 2.3 ==== ==== Task 2.3 ====
Zeile 45: Zeile 43:
  
 ==== Task 2.4 ==== ==== 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';   REVOKE CREATE, ALTER, DROP ON myDatabase.* FROM 'restrictedUser'@'localhost';
Zeile 54: Zeile 52:
   SHOW GRANTS FOR 'restrictedUser'@'localhost';   SHOW GRANTS FOR 'restrictedUser'@'localhost';
      
-{{:modul:m290:learningunits:lu06:aufgaben:a3.png?800|}} 
- 
 ==== Task 2.6 ==== ==== Task 2.6 ====
 **Test the User’s Access**: Establish a new console connection to the database by using //restrictedUser + password//. **Test the User’s Access**: Establish a new console connection to the database by using //restrictedUser + password//.
- 
-{{:modul:m290:learningunits:lu06:aufgaben:a4.png?600|}} 
  
 ==== Task 2.7 ==== ==== 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.
- +
-{{:modul:m290:learningunits:lu06:aufgaben:a5.png?800|}} +
  
 ==== Task 2.8 ==== ==== 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.
- +
-{{:modul:m290:learningunits:lu06:aufgaben:a6.png?800|}}+
  
 ===== Solution ===== ===== Solution =====
  • modul/m290/learningunits/lu06/aufgaben/a02.1730201505.txt.gz
  • Zuletzt geändert: 2024/10/29 12:31
  • von vdemir