{"id":915,"date":"2024-05-07T09:54:12","date_gmt":"2024-05-07T06:54:12","guid":{"rendered":"https:\/\/davidlennuk.wordpress.com\/?page_id=915"},"modified":"2024-09-16T06:55:53","modified_gmt":"2024-09-16T06:55:53","slug":"kasutaja-ja-nende-oigused","status":"publish","type":"page","link":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/","title":{"rendered":"User and their rights"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Loome kasutaja nimega opilaneDavidL parooliga 5527<\/p>\n\n\n\n<p>Kasutaja peab vaatama tabelid(SELECT)<\/p>\n\n\n\n<p>Kasutaja peab lisada andmed tabeli sisse (INSERT)<\/p>\n\n\n\n<p>Muud tegevused ei ole lubatud<\/p>\n\n\n\n<p>Select oli m\u00e4\u00e4ratud db_datareader \u00f5iguse kaudu<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-1.png?w=618\" alt=\"\" class=\"wp-image-919\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-2.png?w=692\" alt=\"\" class=\"wp-image-920\" \/><\/figure>\n\n\n\n<p>CREATE Database kasutajadTAR;<br>USE kasutajadTAR;<\/p>\n\n\n\n<p>CREATE Database kasutajadTAR;<br>USE kasutajadTAR;<\/p>\n\n\n\n<p>&#8211;m\u00e4\u00e4rame INSERT<br>GRANT INSERT to opilaneDavidL;<br>&#8211;keelduda DELETE<br>DENY DELETE to opilaneDavidL;<\/p>\n\n\n\n<p>CREATE TABLE kool(<br>id int primary key,<br>koolNimi varchar(50));<br>SELECT * FROM kool;<br>&#8211;\u00f5iguste m\u00e4\u00e4ramine tabeli p\u00f5hjal<br>GRANT SELECT, INSERT ON kool to opilaneDavidL;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-3.png?w=490\" alt=\"\" class=\"wp-image-923\" \/><\/figure>\n\n\n\n<p>&#8211;kontrolime INSERT<br>INSERT INTO kool(id, koolNimi)<br>VALUES (1, &#8216;TTHK&#8217;);<\/p>\n\n\n\n<p>&#8211;kontrolime DELETE<br>DELETE FROM kool;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-4.png?w=897\" alt=\"\" class=\"wp-image-926\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>&#8211;tabel loomine<br>CREATE TABLE test(id int);<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-5.png?w=572\" alt=\"\" class=\"wp-image-928\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>XAMPP<\/strong><\/p>\n\n\n\n<p id=\"tw-target-text\">\u00f5iguste lisamine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-6.png?w=1024\" alt=\"\" class=\"wp-image-930\" \/><\/figure>\n\n\n\n<p>&#8211;kontrolime DELETE<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-7.png?w=933\" alt=\"\" class=\"wp-image-932\" \/><\/figure>\n\n\n\n<p>&#8211;andmete muutmine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-8.png?w=470\" alt=\"\" class=\"wp-image-934\" \/><\/figure>\n\n\n\n<p id=\"tw-target-text\"><strong>Iseseisev t\u00f6\u00f6<\/strong><\/p>\n\n\n\n<p>\u00dclesanne<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1715067311835_412\"><em>\u0421\u043e\u0437\u0434\u0430\u0442\u044c \u0411\u0414 MovieBase, \u0432\u043d\u0443\u0442\u0440\u0438&nbsp;\u0411\u0414&nbsp;\u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 movies (id, moviesNimi, moviesYear, movieDir&nbsp;\u0438&nbsp;movieCost).<\/em><\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1715067311835_416\"><em>\u0442\u0430\u0431\u043b\u0438\u0446\u0443 guest(id, name)<\/em><\/p>\n\n\n\n<p>\u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u044b 7 \u0437\u0430\u043f\u0438\u0441\u044f\u043c\u0438.<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1715067311835_418\">\u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f&nbsp;<strong>DirectorNimi<\/strong>,&nbsp;\u043f\u0430\u0440\u043e\u043b\u044c&nbsp;<strong>director&nbsp;<\/strong>\u0441 \u043f\u0440\u0430\u0432\u0430\u043c\u0438&nbsp;<\/p>\n\n\n\n<p>1. \u043d\u0430 \u043f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0438&nbsp;\u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 movies&nbsp;\u043f\u043e\u043b\u044f\u0445&nbsp;movieDir&nbsp;\u0438&nbsp;movieCost +&nbsp;1 \u0441\u0432\u043e\u044f \u043f\u0440\u0438\u0432\u0435\u043b\u0435\u0433\u0438\u044f,<\/p>\n\n\n\n<p>2. \u043d\u0430 \u043f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 guest.&nbsp;<\/p>\n\n\n\n<p><em>\u0425\u043e\u0434 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u0437\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0432 \u043a\u043e\u043d\u0441\u043f\u0435\u043a\u0442.<\/em><\/p>\n\n\n\n<p><strong>\u0414\u0430\u0442\u044c \u043f\u0440\u0430\u0432\u0430 \u043d\u0430&nbsp;<\/strong><strong>Update&nbsp;<\/strong><strong>\u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0445 \u043f\u043e\u043b\u0435\u0439<\/strong><strong>:<\/strong><\/p>\n\n\n\n<p>grant update on movies (MovieCost, MovieDir) to DirectorNimi<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p>CREATE Database MovieBase;<br>USE MovieBase;<\/p>\n\n\n\n<p>CREATE TABLE movies(<br>id int primary key,<br>moviesNimi varchar(50),<br>moviesYear int,<br>movieDir varchar(50),<br>movieCost int)<br>SELECT * FROM movies<\/p>\n\n\n\n<p>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (1, &#8216;KOKO&#8217;, 2010, &#8216;Robert Kirkman&#8217;, 14);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (2, &#8216;PING&#8217;, 2016, &#8216;Andrei Tiul&#8217;, 10);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (3, &#8216;Boos&#8217;, 2020, &#8216;Mikhel Rut&#8217;, 18);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (4, &#8216;Piter pen&#8217;, 2009, &#8216;Hirt Sat&#8217;, 15);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (5, &#8216;Hunt&#8217;, 2007, &#8216;Dave Nikol&#8217;, 9);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (6, &#8216;Baby&#8217;, 1998, &#8216;Anton Kurt&#8217;, 7);<br>INSERT INTO movies(id, moviesNimi, moviesYear, movieDir, movieCost)<br>VALUES (7, &#8216;Duni&#8217;, 20007, &#8216;Vlad Kuntin&#8217;, 20);<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-11.png?w=342\" alt=\"\" class=\"wp-image-941\" \/><\/figure>\n\n\n\n<p>CREATE TABLE guest(<br>id int primary key,<br>name varchar(50))<br>SELECT * FROM guest<\/p>\n\n\n\n<p>INSERT INTO guest(id, name)<br>VALUES (1, &#8216;Anton Juri&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (2, &#8216;Kiril Sats&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (3, &#8216;Dima mihail&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (4, &#8216;Vlad Kudrashev&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (5, &#8216;Martin Siild&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (6, &#8216;Timur Nikola&#8217;);<br>INSERT INTO guest(id, name)<br>VALUES (7, &#8216;David Lennuk&#8217;);<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-12.png?w=148\" alt=\"\" class=\"wp-image-943\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-13.png?w=691\" alt=\"\" class=\"wp-image-945\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p id=\"tw-target-text\">t\u00f6\u00f6tab ainult kahe veeru kasutamisel<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-14.png?w=1024\" alt=\"\" class=\"wp-image-948\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-15.png?w=704\" alt=\"\" class=\"wp-image-949\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p><br>pole \u00f5igusi kustutada<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-17.png?w=937\" alt=\"\" class=\"wp-image-952\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p id=\"tw-target-text\">veerge t\u00e4psustavat t\u00e4istabelit ei saa kuidagi avada<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-18.png?w=927\" alt=\"\" class=\"wp-image-954\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-20.png?w=1024\" alt=\"\" class=\"wp-image-957\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p><strong>XAMPP<\/strong><\/p>\n\n\n\n<p id=\"tw-target-text\">\u00d5iguste v\u00e4ljastamine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-21.png?w=1024\" alt=\"\" class=\"wp-image-960\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-24.png?w=1004\" alt=\"\" class=\"wp-image-964\" \/><\/figure>\n\n\n\n<p id=\"tw-target-text\">Kustutamiseks pole \u00f5igusi<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-27.png?w=490\" alt=\"\" class=\"wp-image-969\" \/><\/figure>\n\n\n\n<p><br>V\u00f5imalus andmeid muuta<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-26.png?w=801\" alt=\"\" class=\"wp-image-967\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Loome kasutaja nimega opilaneDavidL parooliga 5527 Kasutaja peab vaatama tabelid(SELECT) Kasutaja peab lisada andmed tabeli sisse (INSERT) Muud tegevused ei ole lubatud Select oli m\u00e4\u00e4ratud db_datareader \u00f5iguse kaudu CREATE Database kasutajadTAR;USE kasutajadTAR; CREATE Database kasutajadTAR;USE kasutajadTAR; &#8211;m\u00e4\u00e4rame INSERTGRANT INSERT to opilaneDavidL;&#8211;keelduda DELETEDENY DELETE to opilaneDavidL; CREATE TABLE kool(id int primary key,koolNimi varchar(50));SELECT * FROM kool;&#8211;\u00f5iguste&hellip; <a class=\"more-link\" href=\"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/\">Continue reading <span class=\"screen-reader-text\">User and their rights<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-915","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>User and their rights - David Lennuk portfoolio || eng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"User and their rights - David Lennuk portfoolio || eng\" \/>\n<meta property=\"og:description\" content=\"Loome kasutaja nimega opilaneDavidL parooliga 5527 Kasutaja peab vaatama tabelid(SELECT) Kasutaja peab lisada andmed tabeli sisse (INSERT) Muud tegevused ei ole lubatud Select oli m\u00e4\u00e4ratud db_datareader \u00f5iguse kaudu CREATE Database kasutajadTAR;USE kasutajadTAR; CREATE Database kasutajadTAR;USE kasutajadTAR; &#8211;m\u00e4\u00e4rame INSERTGRANT INSERT to opilaneDavidL;&#8211;keelduda DELETEDENY DELETE to opilaneDavidL; CREATE TABLE kool(id int primary key,koolNimi varchar(50));SELECT * FROM kool;&#8211;\u00f5iguste&hellip; Continue reading User and their rights\" \/>\n<meta property=\"og:url\" content=\"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/\" \/>\n<meta property=\"og:site_name\" content=\"David Lennuk portfoolio || eng\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-16T06:55:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/\",\"name\":\"User and their rights - David Lennuk portfoolio || eng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-1.png?w=618\",\"datePublished\":\"2024-05-07T06:54:12+00:00\",\"dateModified\":\"2024-09-16T06:55:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/#primaryimage\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-1.png?w=618\",\"contentUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-1.png?w=618\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/kasutaja-ja-nende-oigused\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User and their rights\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"David Lennuk portfoolio || eng\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"User and their rights - David Lennuk portfoolio || eng","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/","og_locale":"en_US","og_type":"article","og_title":"User and their rights - David Lennuk portfoolio || eng","og_description":"Loome kasutaja nimega opilaneDavidL parooliga 5527 Kasutaja peab vaatama tabelid(SELECT) Kasutaja peab lisada andmed tabeli sisse (INSERT) Muud tegevused ei ole lubatud Select oli m\u00e4\u00e4ratud db_datareader \u00f5iguse kaudu CREATE Database kasutajadTAR;USE kasutajadTAR; CREATE Database kasutajadTAR;USE kasutajadTAR; &#8211;m\u00e4\u00e4rame INSERTGRANT INSERT to opilaneDavidL;&#8211;keelduda DELETEDENY DELETE to opilaneDavidL; CREATE TABLE kool(id int primary key,koolNimi varchar(50));SELECT * FROM kool;&#8211;\u00f5iguste&hellip; Continue reading User and their rights","og_url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/","og_site_name":"David Lennuk portfoolio || eng","article_modified_time":"2024-09-16T06:55:53+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/","name":"User and their rights - David Lennuk portfoolio || eng","isPartOf":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/#primaryimage"},"image":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/#primaryimage"},"thumbnailUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-1.png?w=618","datePublished":"2024-05-07T06:54:12+00:00","dateModified":"2024-09-16T06:55:53+00:00","breadcrumb":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/#primaryimage","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-1.png?w=618","contentUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-1.png?w=618"},{"@type":"BreadcrumbList","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/kasutaja-ja-nende-oigused\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"User and their rights"}]},{"@type":"WebSite","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/","name":"David Lennuk portfoolio || eng","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=915"}],"version-history":[{"count":1,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/915\/revisions"}],"predecessor-version":[{"id":1193,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/915\/revisions\/1193"}],"wp:attachment":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}