https://wiki.bzz.ch/ 2026-04-09T04:08:30+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-29T10:55:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu06/aufgaben/a01?rev=1730199309&do=diff LU09.A01 - SQL- DCL: Preparatory Work It is high time to mess a litte around with our new SQL powers, don't you think? So, let's try it directly on our Webstorm. As the database administrator, we want to create a new user and only grant this user the necessary rights to operate the web application, which includes DML operations such as INSERT, UPDATE, DELETE, but not DDL operations such as CREATE or DROP of tables. After all, we don't want the webapplication take control over our database, a… text/html 2024-11-20T13:36:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu06/aufgaben/a02?rev=1732109784&do=diff LU09.A02 - SQL- DCL: CREATE USER It is high time to mess a litte around with our new SQL powers, don't you think? So, let's try it directly on our Webstorm. As the database administrator, we want to create a new user and only grant this user the necessary rights to operate the web application, which includes DML operations such as INSERT, UPDATE, DELETE, but not DDL operations such as CREATE or DROP of tables. After all, we don't want the webapplication take control over our database, are we?