{"id":1015,"date":"2023-06-08T12:33:54","date_gmt":"2023-06-08T12:33:54","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=1015"},"modified":"2023-06-08T12:35:09","modified_gmt":"2023-06-08T12:35:09","slug":"schema","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/schema\/","title":{"rendered":"Schema"},"content":{"rendered":"\n

SQL Server 2005 on iga objekti poole v\u00f5imalik p\u00f6\u00f6rduda objekti t\u00e4ispika nime kaudu. T\u00e4ispikk nimi koosneb neljast osast ning on kujul server.andmebaas.schema.nimi. T\u00e4ispikast nimest on v\u00f5imalik \u00e4ra j\u00e4tta k\u00f5ik peale objekti nime. Schemad e nimeruumid v\u00f5imaldavad andmebaasi objekte loogiliselt grupeerida ning selle abil on lihtsam hallata ligip\u00e4\u00e4su\u00f5iguseid. Ligip\u00e4\u00e4su on seega v\u00f5imalik seadistada serveri tasemel, andmebaasi tasemel, schema tasemel ning loomulikult ka objekti tasemel.<\/p>\n\n\n\n

Schema loomiseks on CREATE SCHEMA lause:<\/p>\n\n\n

\nCREATE SCHEMA yldasjad\n<\/pre><\/div>\n\n\n
Tabelite lisamiseks konkreetsesse nimeruumi tuleb tabeli loomisel n\u00e4idata \u00e4ra, millisesse nimeruumi tabel l\u00e4heb. Vaikimisi on igas andmebaasis kasutusel v\u00e4hemalt \u00fcks nimeruum dbo.<\/p>\n\n\n\n
Lisame nimeruumi \u00fcldasjad tabeli proovikas:<\/p>\n\n\n
\nCREATE TABLE yldasjad.proovikas \n(\n\tID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,\n\tMingiInf VARCHAR(100) NOT NULL\n)\n<\/pre><\/div>\n\n\n
Igale kasutajale on v\u00f5imalik m\u00e4\u00e4rata default schema:<\/p>\n\n\n
\nCREATE USER [tegijad] \nFOR LOGIN [BUILTIN\\Users] \nWITH DEFAULT_SCHEMA=[yldasjad]\n<\/pre><\/div>\n\n\n
Kui kasutaja ei t\u00e4psusta objekti loomisel\/kasutamisel nimeruumi p\u00f6\u00f6rdutakse tema default nimeruumi poole. Kui sealt objekti ei leita otsitakse objekti dbo nimeruumist.<\/p>\n\n\n\n
Lisaks sellele on v\u00f5imalik igale kasutajale v\u00f5i kasutajate grupile e. rollile m\u00e4\u00e4rata, milliseid tegevusi ta nimeruumis v\u00f5ib teha:<\/p>\n\n\n\n
Taas on v\u00f5imalik k\u00f5ike korraldada ka kasutades SQL Lauseid:<\/p>\n\n\n
\nGRANT ALTER ON SCHEMA::[yldasjad] TO [public]\nGRANT SELECT ON SCHEMA::[yldasjad] TO [public]\nDENY TAKE OWNERSHIP ON SCHEMA::[yldasjad] TO [public]\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
SQL Server 2005 on iga objekti poole v\u00f5imalik p\u00f6\u00f6rduda objekti t\u00e4ispika nime kaudu. T\u00e4ispikk nimi koosneb neljast osast ning on kujul server.andmebaas.schema.nimi. T\u00e4ispikast nimest on v\u00f5imalik \u00e4ra j\u00e4tta k\u00f5ik peale objekti nime. Schemad e nimeruumid v\u00f5imaldavad andmebaasi objekte loogiliselt grupeerida ning selle abil on lihtsam hallata ligip\u00e4\u00e4su\u00f5iguseid. Ligip\u00e4\u00e4su on seega v\u00f5imalik seadistada serveri tasemel, andmebaasi … Loe edasi Schema<\/span> →<\/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-1015","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=1015"}],"version-history":[{"count":6,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1015\/revisions"}],"predecessor-version":[{"id":1023,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/1015\/revisions\/1023"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=1015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}