{"id":92114,"date":"2020-08-23T19:41:56","date_gmt":"2020-08-23T17:41:56","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql"},"modified":"2020-08-23T19:41:56","modified_gmt":"2020-08-23T17:41:56","slug":"realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","title":{"rendered":"Lomas pieejas mode\u013ca \u012bsteno\u0161ana, izmantojot Row Level Security PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>T\u0113mas att\u012bst\u012bba <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515896\/\">Et\u012bde par Row Level Security ievie\u0161anu PostgreSQL<\/a><\/noindex> un <b>lai sniegtu detaliz\u0113tu atbildi<\/b> uz <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515628\/#comment_21973176\">koment\u0101rs.<\/a><\/noindex><\/p>\n<p>Izmantot\u0101 strat\u0113\u0123ija paredz \u00abBiznesa lo\u0123ikas datub\u0101z\u0113\u00bb koncepcijas izmanto\u0161anu, kas tika nedaudz s\u012bk\u0101k aprakst\u012bta \u0161eit \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515628\/\">Studija par biznesa lo\u0123ikas realiz\u0101ciju PostgreSQL uzglab\u0101\u0161anas funkciju l\u012bmen\u012b<\/a><\/noindex><\/p>\n<p>Teor\u0113tisk\u0101 da\u013ca ir lieliski aprakst\u012bta dokument\u0101cij\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/\">Postgres Pro<\/a><\/noindex> \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgrespro\/11\/ddl-rowsecurity\">Rindu aizsardz\u012bbas politikas<\/a><\/noindex>. Zem\u0101k apskat\u012bta praktisk\u0101 realiz\u0101cija <b>konkr\u0113tai biznesa uzdevumam \u2014 piek\u013cuves mode\u013ca izveide datiem.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Lomas pieejas mode\u013ca \u012bsteno\u0161ana, izmantojot Row Level Security PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/08\/df69397b8638421732a67e457c99857c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<blockquote><p>Rakst\u0101 nav nekas jauns, nav sl\u0113pta j\u0113ga vai nosl\u0113pumu. T\u0101 ir vienk\u0101r\u0161a piez\u012bme par praktisk\u0101s realiz\u0101cijas teor\u0113tisko ideju. Ja k\u0101du interes\u0113 \u2014 lasiet. Kam neinteres\u0113 \u2014 net\u0113r\u0113jiet savu laiku velti.<\/p><\/blockquote>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Uzdevuma formul\u0113\u0161ana<\/h2>\n<p>\nNepiecie\u0161ams nodal\u012bt piek\u013cuvi dokumenta apskatei\/ievadei\/izmai\u0146\u0101m\/dz\u0113\u0161anai atbilsto\u0161i lietot\u0101ja lomai. Ar lomu saprotams ieraksts tabul\u0101 <b>roles<\/b> kas ir saist\u012bts ar daudzk\u0101r\u0161u attiec\u012bbu ar tabulu <b>lietot\u0101ji<\/b>. Tabulu realiz\u0101cijas deta\u013cas, \u0146emot v\u0113r\u0101 trivialit\u0101ti, ir izsl\u0113gtas. Ar\u012b konkr\u0113t\u0101s realiz\u0101cijas deta\u013cas, kas saist\u012btas ar priek\u0161metu jomu, ir izsl\u0113gtas.<\/p>\n<h2>Realiz\u0101cija<\/h2>\n<p><\/p>\n<h4>Izveidojam lomas, sh\u0113mas, tabulu<\/h4>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">Datub\u0101zu objektu izveide<\/b><\/p>\n<pre><code class=\"pgsql\">CREATE ROLE store;\nCREATE SCHEMA store AUTHORIZATION store;\nCREATE TABLE store.docs\n(\n  id integer ,         --dokumenta id\n  man_id integer , --dokumenta mened\u017eera id\n  stat_id integer ,  --dokumenta statusa id\n  ...\n  is_del BOOLEAN DEFAULT FALSE \n);\nALTER TABLE store.docs ADD CONSTRAINT doc_pk PRIMARY KEY (id);\nALTER TABLE store.docs OWNER TO store ;\n<\/code><\/pre>\n<p><\/p>\n<h4>Izveidojam funkcijas RLS realiz\u0101cijai<\/h4>\n<p>\nP\u0101rbaude, vai var veikt SELECT rindi\u0146u<\/p>\n<p>                        <b class=\"spoiler_title\">check_select<\/b><\/p>\n<pre><code class=\"pgsql\">IZVEIDOJAM VAI AIZST\u0100JAM FUNKCIJU store.check_select ( current_id store.docs.id%TYPE ) ATGRIE\u017d BOOLEAN AS $$\nDECLARE\n  result BOOLEAN ;\n  curr_pid INTEGER ;\n  curr_stat_id INTEGER ;\n  doc_man_id INTEGER ;\nBEGIN \n  -- DBA ir piek\u013cuve visiem dokumentiem\n  IF SESSION_USER = 'curr_dba'\n  THEN\n    ATGRIE\u017d TRUE ;\n  END IF ;\n  --------------------------------\n\n  --Ja dokuments ir apz\u012bm\u0113ts ar 'izdz\u0113sts' - nedemonstr\u0113t izv\u0113l\u0113\n  SELECT\n    is_del\n  INTO\n    result\n  FROM\n    store.docs\n  WHERE\n    id = current_id ;\n IF result = TRUE\n THEN\n   ATGRIE\u017d FALSE ;\n END IF ;\n --------------------------------\n\n --Ieg\u016bt pa\u0161reiz\u0113j\u0101 lietot\u0101ja id\n SELECT\n   service_function.get_curr_pid ()\n INTO\n   curr_pid ;\n --------------------------------\n\n --Ieg\u016bt dokumenta mened\u017eera id\n SELECT\n   man_id\n INTO\n   doc_man_id\n FROM\n   store.docs\n WHERE\n   id = current_id ;\n --------------------------------\n\n --Ja dokumenta mened\u017eeris nav pa\u0161reiz\u0113jais lietot\u0101js vai mened\u017eeris nav noteikts\n --pievienot dokumentu izv\u0113lei\n IF doc_man_id != curr_pid OR doc_man_id IS NULL\n THEN\n   ATGRIE\u017d TRUE  ;\n ELSE\n   --Ieg\u016bt dokumenta pa\u0161reiz\u0113jo statusu\n   SELECT\n     stat_id                                         \n   INTO\n     curr_statid\n   FROM\n     store.docs\n   WHERE\n     id = current_id ;\n    \n   --Ja statuss at\u013cauj apskat\u012bt dokumentu - pievienot dokumentu izv\u0113lei                     \n   IF curr_statid = 4 OR curr_statid = 9\n   THEN\n     ATGRIE\u017d TRUE ;\n   ELSE\n   --Pret\u0113j\u0101 gad\u012bjum\u0101 - izsl\u0113gt dokumentu no izv\u0113les\n     ATGRIE\u017d FALSE ;\n    END IF ;\n  END IF ;\n  --------------------------------\n\n ATGRIE\u017d FALSE ;\nEND\n$$ VALODA plpgsql DRO\u0160\u012aBAS DEFIN\u012aTORS;\nALTER FUNCTION store.check_select( store.docs.id%TYPE  ) PIEDER STORE ;\nAT\u0172REVI EXECUTE ON FUNCTION store.check_select( store.docs.id%TYPE  ) FROM public; \nPIE\u0160\u0136IR EXECUTE ON FUNCTION store.check_select( store.docs.id%TYPE  ) TO service_functions; \n<\/code><\/pre>\n<p>\nP\u0101rbaude par iesp\u0113ju veikt INSERT rindas<\/p>\n<p>                        <b class=\"spoiler_title\">check_insert<\/b><\/p>\n<pre><code class=\"pgsql\">IZVEIDOJAM VAI AIZST\u0100JAM FUNKCIJU store.check_insert ( current_id store.docs.id%TYPE ) ATGRIE\u017d BOOLEAN AS $$\nDECLARE\n  curr_role_id INTEGER ;\nBEGIN\n  --DBA var pievienot rindu jebkur\u0101 gad\u012bjum\u0101\n  IF SESSION_USER = 'curr_dba'\n  THEN\n    ATGRIE\u017d TRUE ;\n  END IF ;\n  --------------------------------\n\n --Ieg\u016bt pa\u0161reiz\u0113j\u0101 lietot\u0101ja lomas id \n SELECT\n   service_functions.current_rid()\n  INTO\n    curr_role_id ;\n --------------------------------\n\n--Ja loma at\u013cauj jauna dokumenta izveidi\n--at\u013caut\nIF curr_role_id = 3 OR curr_role_id = 5     \nTHEN\n  ATGRIE\u017d TRUE ;\nEND IF ;\n--------------------------------\nATGRIE\u017d FALSE  ;\nEND\n$$ VALODA plpgsql DRO\u0160\u012aBAS DEFIN\u012aTORS;\nALTER FUNCTION store.check_insert( store.docs.id%TYPE  ) PIEDER STORE ;\nAT\u0172REVI EXECUTE ON FUNCTION store.check_insert( store.docs.id%TYPE  ) FROM public;\nPIE\u0160\u0136IR EXECUTE ON FUNCTION store.check_insert( store.docs.id%TYPE  ) TO service_functions; \n<\/code><\/pre>\n<p>\nP\u0101rbaude par iesp\u0113ju veikt DELETE rindas<\/p>\n<p>                        <b class=\"spoiler_title\">check_delete<\/b><\/p>\n<pre><code class=\"pgsql\">IZVEIDOJAM VAI AIZST\u0100JAM FUNKCIJU store.check_delete ( current_id store.docs.id%TYPE )\nATGRIE\u017d BOOLEAN AS $$\nBEGIN  \n  --Tikai DBA var dz\u0113st rindu \n  IF SESSION_USER = 'curr_dba'\n  THEN\n    ATGRIE\u017d TRUE ;\n  END IF ;\n  --------------------------------\n\n  ATGRIE\u017d FALSE ;\nEND\n$$ VALODA plpgsql\nDRO\u0160\u012aBAS DEFIN\u012aTORS;\nALTER FUNCTION store.check_delete( store.docs.id%TYPE  ) PIEDER STORE ;\nAT\u0172REVI EXECUTE ON FUNCTION store.check_delete( store.docs.id%TYPE  ) FROM public;<\/code><\/pre>\n<p>\nP\u0101rbaude par iesp\u0113ju veikt UPDATE rindas.<\/p>\n<p>                        <b class=\"spoiler_title\">update_using<\/b><\/p>\n<pre><code class=\"pgsql\">IZVEIDOJIET VAI NOSTA\u010cIET FUNKCIJU store.update_using ( current_id store.docs.id%TYPE , is_del boolean )\nRETURNS boolean AS $$\nS\u0100KT\n   --Dokumenti ar statusu 'dz\u0113sts' netiek redi\u0123\u0113ti\n   JA is_del \n   TAD\n     ATGRIEZT FALSE ;\n CITADIEN\n    ATGRIEZT TRUE ;\n  BEIGAS\n\nBEIGAS\n$$ LANGUAGE plpgsql SECURITY DEFINER;\nALTER FUNCTION store.update_using( store.docs.id%TYPE , boolean ) OWNER TO store ;\nREVOKE EXECUTE ON FUNCTION store.update_using( store.docs.id%TYPE , boolean ) FROM public;\nGRANT EXECUTE ON FUNCTION store.update_using( store.docs.id%TYPE ) TO service_functions;<\/code><\/pre>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">update_check<\/b><\/p>\n<pre><code class=\"pgsql\">IZVEIDOJIET VAI NOSTA\u010cIET FUNKCIJU store.update_with_check ( current_id store.docs.id%TYPE , is_del boolean )\nRETURNS boolean AS $$\nDECLARE\n  current_rid integer ;\n  current_statid integer ;\nS\u0100KT                \n\n  --DBA var apskat\u012bt rindu \n  JA SESSION_USER = 'curr_dba'\n  TAD\n    ATGRIEZT TRUE ;\n  BEIGAS\n  --------------------------------\n\n --Ieg\u016bt current_rid\n SELECT\n   service_functions.current_rid()\n  IEVEST\n    curr_role_id ;\n --------------------------------                            \n\n --Dokumenta izdz\u0113\u0161ana - statusa mai\u0146a \n JA is_deleted\n TAD\n   --Ja lietot\u0101ja loma ***\n   JA current_role_id = 3        \n   TAD\n      SELECT\n        stat_id                                          \n      IEVEST\n        curr_statid\n      NO\n        store.docs\n      KUR\n        id = current_id ;\n\n      --Dokuments status\u0101 *** nevar tikt izdz\u0113sts \n      JA current_status_id = 11\n      TAD\n         ATGRIEZT FALSE ;\n      CITADIEN\n      --Var izdz\u0113st dokumentu citos statusos\n        ATGRIEZT TRUE ;\n      BEIGAS\n\n    --Cit\u0101di, ja loma ***\n    ELSIF current_role_id = 5            \n    TAD\n      --Visi dokumenta statusi \n      ATGRIEZT TRUE ;\n    CITADIEN\n      --Citi lietot\u0101ji nevar izdz\u0113st dokumentus\n      ATGRIEZT FALSE ;\n    BEIGAS\n ELSI      \n   --Dokumenta atjaunin\u0101\u0161ana ir at\u013cauta\n    ATGRIEZT TRUE ;\nBEIGAS\n\nATGRIEZT FALSE ;\nBEIGAS\n$$ LANGUAGE plpgsql SECURITY DEFINER;\nALTER FUNCTION store.update_with_check( storg.docs.id%TYPE , boolean ) OWNER TO store ;\nREVOKE EXECUTE ON FUNCTION store.update_with_check( storg.docs.id%TYPE , boolean ) FROM public;\nGRANT EXECUTE ON FUNCTION store.update_with_check( store.docs.id%TYPE ) TO service_functions;<\/code><\/pre>\n<p>\nRow Level Security politikas aktiviz\u0101cija tabulai.<\/p>\n<p>                        <b class=\"spoiler_title\">IESP\u0112JOT RINDU L\u012aME\u0145A DRO\u0160\u012aBU<\/b><\/p>\n<pre><code class=\"pgsql\">ALTER TABLE store.docs IESP\u0112JOT RINDU L\u012aME\u0145A DRO\u0160\u012aBU ;\n\nIZVEIDOT POLITIKU doc_select ON store.docs FOR SELECT TO service_functions USING ( (SELECT store.check_select(id)) );\nIZVEIDOT POLITIKU doc_insert ON store.docs FOR INSERT TO service_functions WITH CHECK ( (SELECT store.check_insert(id)) );\nIZVEIDOT POLITIKU docs_delete ON store.docs FOR DELETE TO service_functions USING ( (SELECT store.check_delete(id)) );\n\nIZVEIDOT POLITIKU doc_update_using ON store.docs FOR UPDATE TO service_functions USING ( (SELECT store.update_using(id , is_del )) );\nIZVEIDOT POLITIKU doc_update_check ON store.docs FOR UPDATE TO service_functions WITH CHECK ( (SELECT store.update_with_check(id , is_del )) );<\/code><\/pre>\n<p><\/p>\n<h2>Rezult\u0101ts<\/h2>\n<p>\nTas darbojas.<\/p>\n<p>Ieteikt\u0101 strat\u0113\u0123ija \u013c\u0101va p\u0101rs\u016bt\u012bt lomu mode\u013ca \u012bsteno\u0161anu no biznesa funkciju l\u012bme\u0146a uz datu glab\u0101\u0161anas l\u012bmeni. <\/p>\n<p>Funkcijas var izmantot k\u0101 paraugu sare\u017e\u0123\u012bt\u0101ku datu sl\u0113p\u0161anas mode\u013cu \u012bsteno\u0161anai, ja to prasa biznesa pras\u012bbas.<br \/>\n<br \/>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/516040\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u0442\u0435\u0433\u0438\u044f \u043f\u043e\u0434\u0440\u0430\u0437\u0443\u043c\u0435\u0432\u0430\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u0438 \u00ab\u0411\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0430 \u0432 \u0411\u0414\u00bb, \u0447\u0442\u043e \u0431\u044b\u043b\u043e \u0447\u0443\u0442\u044c \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u043e \u0437\u0434\u0435\u0441\u044c \u2014 \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 PostgreSQL \u0422\u0435\u043e\u0440\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0432 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438 Postgres Pro \u2014 \u041f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0437\u0430\u0449\u0438\u0442\u044b \u0441\u0442\u0440\u043e\u043a. \u041d\u0438\u0436\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":92115,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-92114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0435\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Row Level Security \u0432 PostgreSQL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-08-23T17:41:56+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-08-23T17:41:56+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Lomas piek\u013cuves mode\u013ca \u012bsteno\u0161ana, izmantojot Row Level Security PostgreSQL | ProHoster","description":"T\u0113mas att\u012bst\u012bba par Row Level Security \u012bsteno\u0161anu PostgreSQL un detaliz\u0113ta atbilde uz","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0435\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Row Level Security \u0432 PostgreSQL | ProHoster","og:description":"\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430","og:url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-08-23T17:41:56+00:00","article:modified_time":"2020-08-23T17:41:56+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"92114","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 12:14:23","updated":"2022-10-06 10:04:45","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/92114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=92114"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/92114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/92115"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=92114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=92114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=92114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}