{"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\/cs\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","title":{"rendered":"Implementace modelu \u0159\u00edzen\u00ed p\u0159\u00edstupu s vyu\u017eit\u00edm Row Level Security v PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Rozvoj t\u00e9matu <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515896\/\">Studie implementace Row Level Security v PostgreSQL<\/a><\/noindex> a <b>pro podrobnou odpov\u011b\u010f<\/b> na <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515628\/#comment_21973176\">koment\u00e1\u0159.<\/a><\/noindex><\/p>\n<p>Pou\u017eit\u00e1 strategie p\u0159edpokl\u00e1d\u00e1 koncept \u201ePodnikov\u00e1 logika v DB\u201c, co\u017e bylo podrobn\u011bji pops\u00e1no zde \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/515628\/\">Studie o implementaci obchodn\u00ed logiky na \u00farovni ulo\u017een\u00fdch funkc\u00ed PostgreSQL<\/a><\/noindex><\/p>\n<p>Teoretick\u00e1 \u010d\u00e1st je v\u00fdborn\u011b pops\u00e1na v dokumentaci <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\">Politiky ochrany \u0159\u00e1dk\u016f<\/a><\/noindex>. N\u00ed\u017ee je uvedena praktick\u00e1 implementace <b>konkr\u00e9tn\u00ed obchodn\u00ed \u00falohy \u2014 role modelu p\u0159\u00edstupu k dat\u016fm.<\/b><\/p>\n<p><img decoding=\"async\" alt=\"Implementace modelu \u0159\u00edzen\u00ed p\u0159\u00edstupu s vyu\u017eit\u00edm Row Level Security v PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/08\/df69397b8638421732a67e457c99857c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<blockquote><p>V \u010dl\u00e1nku nen\u00ed nic nov\u00e9ho, \u017e\u00e1dn\u00fd skryt\u00fd smysl ani tajn\u00e9 znalosti. Jen skica o praktick\u00e9 realizaci teoretick\u00e9 my\u0161lenky. Pokud m\u00e1 n\u011bkdo z\u00e1jem \u2014 \u010dtete. Kdo nem\u00e1 z\u00e1jem \u2014 neztr\u00e1cejte zbyte\u010dn\u011b \u010das.<\/p><\/blockquote>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Formulace \u00fakolu<\/h2>\n<p>\nJe nutn\u00e9 rozli\u0161it p\u0159\u00edstup k prohl\u00ed\u017een\u00ed\/vkl\u00e1d\u00e1n\u00ed\/zm\u011bn\u011b\/odstran\u011bn\u00ed dokumentu podle role u\u017eivatele aplikace. Pod rol\u00ed se rozum\u00ed z\u00e1znam v tabulce <b>role<\/b> spojen\u00e9 vztahy mnoha-k-mnoh\u00fdm s tabulkou <b>users<\/b>. Detaily implementace tabulek, z d\u016fvodu trivi\u00e1lnosti, byly vynech\u00e1ny. Tak\u00e9 byly vynech\u00e1ny konkr\u00e9tn\u00ed detaily implementace t\u00fdkaj\u00edc\u00ed se p\u0159edm\u011btn\u00e9 oblasti.<\/p>\n<h2>Implementace<\/h2>\n<p><\/p>\n<h4>Vytv\u00e1\u0159\u00edme role, sch\u00e9mata, tabulku<\/h4>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">Vytvo\u0159en\u00ed objekt\u016f DB<\/b><\/p>\n<pre><code class=\"pgsql\">CREATE ROLE store;\nCREATE SCHEMA store AUTHORIZATION store;\nCREATE TABLE store.docs\n(\n  id integer ,         --id dokumentu\n  man_id integer , --id mana\u017eera dokumentu\n  stat_id integer ,  --id stavu dokumentu\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>Vytv\u00e1\u0159\u00edme funkce pro implementaci RLS<\/h4>\n<p>\nOv\u011b\u0159en\u00ed mo\u017enosti prov\u00e9st SELECT \u0159\u00e1dku<\/p>\n<p>                        <b class=\"spoiler_title\">check_select<\/b><\/p>\n<pre><code class=\"pgsql\">VYTVO\u0158IT NEBO NAHRADIT FUNKCI store.check_select ( current_id store.docs.id%TYPE ) VRAC\u00cd boolean AS $$\nDECLARE\n  v\u00fdsledek boolean ;\n  curr_pid integer ;\n  curr_stat_id integer ;\n  doc_man_id integer ;\nBEGIN \n  -- DBA m\u00e1 p\u0159\u00edstup ke v\u0161em dokument\u016fm\n  IF SESSION_USER = 'curr_dba'\n  THEN\n    RETURN TRUE ;\n  END IF ;\n  --------------------------------\n\n  --Pokud je dokument ozna\u010den jako 'smazan\u00fd' - nezobrazovat v v\u00fdb\u011bru\n  SELECT\n    is_del\n  INTO\n    v\u00fdsledek\n  FROM\n    store.docs\n  WHERE\n    id = current_id ;\n IF v\u00fdsledek = TRUE\n THEN\n   RETURN FALSE ;\n END IF ;\n --------------------------------\n\n --Z\u00edskat id aktu\u00e1ln\u00edho u\u017eivatele\n SELECT\n   service_function.get_curr_pid ()\n INTO\n   curr_pid ;\n --------------------------------\n\n --Z\u00edskat id mana\u017eera dokumentu\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 --Pokud mana\u017eer dokumentu nen\u00ed aktu\u00e1ln\u00ed u\u017eivatel nebo mana\u017eer nen\u00ed p\u0159id\u011blen\n --p\u0159idat dokument do v\u00fdb\u011bru\n IF doc_man_id != curr_pid OR doc_man_id IS NULL\n THEN\n   RETURN TRUE  ;\n ELSE\n   --Z\u00edskat aktu\u00e1ln\u00ed stav dokumentu\n   SELECT\n     stat_id                                         \n   INTO\n     curr_statid\n   FROM\n     store.docs\n   WHERE\n     id = current_id ;\n    \n   --Pokud stav umo\u017e\u0148uje zobrazen\u00ed dokumentu - p\u0159idat dokument do v\u00fdb\u011bru                     \n   IF curr_statid = 4 OR curr_statid = 9\n   THEN\n     RETURN TRUE ;\n   ELSE\n   --Jinak - vylou\u010dit dokument z v\u00fdb\u011bru\n     RETURN FALSE ;\n    END IF ;\n  END IF ;\n  --------------------------------\n\n RETURN FALSE ;\nEND\n$$ JAZYK plpgsql SECURITY DEFINER;\nALTER FUNCTION store.check_select( store.docs.id%TYPE  ) VLASTN\u00cdK TO store ;\nODEBRAT EXECUTE ON FUNCTION store.check_select( store.docs.id%TYPE  ) FROM public; \nUD\u011aLIT EXECUTE ON FUNCTION store.check_select( store.docs.id%TYPE  ) TO service_functions; \n<\/code><\/pre>\n<p>\nKontrola mo\u017enosti prov\u00e9st INSERT \u0159\u00e1dku<\/p>\n<p>                        <b class=\"spoiler_title\">check_insert<\/b><\/p>\n<pre><code class=\"pgsql\">VYTVO\u0158IT NEBO NAHRADIT FUNKCI store.check_insert ( current_id store.docs.id%TYPE ) VRAC\u00cd boolean AS $$\nDECLARE\n  curr_role_id integer ;\nBEGIN\n  --DBA m\u016f\u017ee p\u0159id\u00e1vat \u0159\u00e1dek za jak\u00fdchkoli okolnost\u00ed\n  IF SESSION_USER = 'curr_dba'\n  THEN\n    RETURN TRUE ;\n  END IF ;\n  --------------------------------\n\n --Z\u00edskat id role aktu\u00e1ln\u00edho u\u017eivatele \n SELECT\n   service_functions.current_rid()\n  INTO\n    curr_role_id ;\n --------------------------------\n\n--Pokud role umo\u017e\u0148uje mo\u017enost vytvo\u0159en\u00ed nov\u00e9ho dokumentu\n--povolit\nIF curr_role_id = 3 OR curr_role_id = 5     \nTHEN\n  RETURN TRUE ;\nEND IF ;\n--------------------------------\nRETURN FALSE  ;\nEND\n$$ JAZYK plpgsql SECURITY DEFINER;\nALTER FUNCTION store.check_insert( store.docs.id%TYPE  ) VLASTN\u00cdK TO store ;\nODEBRAT EXECUTE ON FUNCTION store.check_insert( store.docs.id%TYPE  ) FROM public;\nUD\u011aLIT EXECUTE ON FUNCTION store.check_insert( store.docs.id%TYPE  ) TO service_functions; \n<\/code><\/pre>\n<p>\nKontrola mo\u017enosti prov\u00e9st DELETE \u0159\u00e1dku<\/p>\n<p>                        <b class=\"spoiler_title\">check_delete<\/b><\/p>\n<pre><code class=\"pgsql\">VYTVO\u0158IT NEBO NAHRADIT FUNKCI store.check_delete ( current_id store.docs.id%TYPE )\nVRAC\u00cd boolean AS $$\nBEGIN  \n  --Pouze DBA m\u016f\u017ee odstranit \u0159\u00e1dek \n  IF SESSION_USER = 'curr_dba'\n  THEN\n    RETURN TRUE ;\n  END IF ;\n  --------------------------------\n\n  RETURN FALSE ;\nEND\n$$ JAZYK plpgsql\nSECURITY DEFINER;\nALTER FUNCTION store.check_delete( store.docs.id%TYPE  ) VLASTN\u00cdK TO store ;\nODEBRAT EXECUTE ON FUNCTION store.check_delete( store.docs.id%TYPE  ) FROM public;<\/code><\/pre>\n<p>\nKontrola mo\u017enosti prov\u00e9st UPDATE \u0159\u00e1dku.<\/p>\n<p>                        <b class=\"spoiler_title\">aktualizace_pou\u017eit\u00ed<\/b><\/p>\n<pre><code class=\"pgsql\">VYTVO\u0158IT NEBO NAHRADIT FUNKCI store.update_using ( current_id store.docs.id%TYPE , is_del boolean )\nVRAC\u00cd boolean AS $$\nZA\u010c\u00cdT  \n   --Dokumenty se statusem 'smaz\u00e1no' - nelze upravovat\n   IF is_del \n   THEN\n     VR\u00c1TIT FALSE ;\n ELSE\n    VR\u00c1TIT TRUE ;\n  END IF ;\n\nKONEC\n$$ JAZYK plpgsql BEZPE\u010cNOSTN\u00cd DEFINER;\nZMI\u011aNIT FUNKCI store.update_using( store.docs.id%TYPE ,  boolean  ) VLASTN\u00cdK NA store ;\nODEBRAT PROV\u00c1D\u011aN\u00cd NA FUNKCI store.update_using( store.docs.id%TYPE ,  boolean  ) OD public;\nUD\u011aLIT PROV\u00c1D\u011aN\u00cd NA FUNKCI store.update_using( store.docs.id%TYPE  ) PRO service_functions;<\/code><\/pre>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">aktualizace_zkontrolovat<\/b><\/p>\n<pre><code class=\"pgsql\">VYTVO\u0158IT NEBO NAHRADIT FUNKCI store.update_with_check ( current_id store.docs.id%TYPE , is_del boolean )\nVRAC\u00cd boolean AS $$\nDECLARE\n  current_rid integer ;\n  current_statid integer ;\nZA\u010c\u00cdT                \n\n  --DBA m\u016f\u017ee prohl\u00ed\u017eet \u0159\u00e1dek \n  IF SESSION_USER = 'curr_dba'\n  THEN\n    VR\u00c1TIT TRUE ;\n  END IF ;\n  --------------------------------\n\n --Z\u00edskat id role aktu\u00e1ln\u00edho u\u017eivatele \n SELECT\n   service_functions.current_rid()\n  DO\n    curr_role_id ;\n --------------------------------                            \n\n --Smaz\u00e1n\u00ed dokumentu - zm\u011bna znaku \n IF is_deleted\n THEN\n   --Pokud je role u\u017eivatele ***\n   IF current_role_id = 3        \n   THEN\n      SELECT\n        stat_id                                          \n      DO\n        curr_statid\n      FROM\n        store.docs\n      WHERE\n        id = current_id ;\n\n      --Dokument ve stavu *** nelze smazat \n      IF current_status_id = 11\n      THEN\n         VR\u00c1TIT FALSE ;\n      ELSE\n      --Dokument lze smazat v jin\u00fdch stavech\n        VR\u00c1TIT TRUE ;\n      END IF ;\n\n    --Jinak, pokud je role u\u017eivatele ***\n    ELSIF current_role_id = 5            \n    THEN\n      --V\u0161echny stavy dokumentu \n      VR\u00c1TIT TRUE ;\n    ELSE\n      --Jin\u00ed u\u017eivatel\u00e9 nemohou dokumenty mazat\n      VR\u00c1TIT FALSE ;\n    END IF ;\n ELSE      \n   --Aktualizace dokumentu povolena\n    VR\u00c1TIT TRUE ;\nEND IF ;\n\nVR\u00c1TIT FALSE ;\nEND\n$$ JAZYK plpgsql BEZPE\u010cNOSTN\u00cd DEFINER;\nZMI\u011aNIT FUNKCI store.update_with_check( storg.docs.id%TYPE ,  boolean   ) VLASTN\u00cdK NA store ;\nODEBRAT PROV\u00c1D\u011aN\u00cd NA FUNKCI store.update_with_check( storg.docs.id%TYPE ,  boolean   )  OD public;\nUD\u011aLIT PROV\u00c1D\u011aN\u00cd NA FUNKCI store.update_with_check( store.docs.id%TYPE  ) PRO service_functions;<\/code><\/pre>\n<p>\nAktivace politiky Row Level Security pro tabulku.<\/p>\n<p>                        <b class=\"spoiler_title\">POVOLIT BEZPE\u010cNOST \u0158\u00c1DK\u016e<\/b><\/p>\n<pre><code class=\"pgsql\">ZMI\u011aNIT TABULKU store.docs POVOLIT BEZPE\u010cNOST \u0158\u00c1DK\u016e ;\n\nVYTVO\u0158IT POLITIKU doc_select NA store.docs PRO SELECT PRO service_functions POU\u017dIT\u00cd ( (SELECT store.check_select(id)) );\nVYTVO\u0158IT POLITIKU doc_insert NA store.docs PRO INSERT PRO service_functions S ODV\u011aTCHA ( (SELECT store.check_insert(id)) );\nVYTVO\u0158IT POLITIKU docs_delete NA store.docs PRO DELETE PRO service_functions POU\u017dIT\u00cd ( (SELECT store.check_delete(id)) );\n\nVYTVO\u0158IT POLITIKU doc_update_using NA store.docs PRO UPDATE PRO service_functions POU\u017dIT\u00cd ( (SELECT store.update_using(id , is_del )) );\nVYTVO\u0158IT POLITIKU doc_update_check NA store.docs PRO UPDATE PRO service_functions  S ODV\u011aTCHA ( (SELECT store.update_with_check(id , is_del )) );<\/code><\/pre>\n<p><\/p>\n<h2>V\u00fdsledek<\/h2>\n<p>\nTo funguje.<\/p>\n<p>Navrhovan\u00e1 strategie umo\u017enila p\u0159en\u00e9st implementaci modelu rol\u00ed z \u00farovn\u011b obchodn\u00edch funkc\u00ed na \u00farove\u0148 ukl\u00e1d\u00e1n\u00ed dat. <\/p>\n<p>Funkce mohou b\u00fdt pou\u017eity jako \u0161ablona pro implementaci slo\u017eit\u011bj\u0161\u00edch model\u016f skr\u00fdv\u00e1n\u00ed dat, pokud to vy\u017eaduj\u00ed obchodn\u00ed pot\u0159eby.<br \/>\n<br \/>Zdroj: <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.3 - 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\/cs\/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.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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\udd47Implementace role-based modelu p\u0159\u00edstupu s vyu\u017eit\u00edm Row Level Security v PostgreSQL | ProHoster","description":"Rozvoj t\u00e9matu \u00c9tuda o implementaci Row Level Security v PostgreSQL a pro podrobnou odpov\u011b\u010f na","canonical_url":"https:\/\/prohoster.info\/cs\/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":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/92114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=92114"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/92114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/92115"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=92114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=92114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=92114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}