{"id":296,"date":"2026-01-25T01:58:38","date_gmt":"2026-01-24T17:58:38","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9104-row-level-security-rls-%e6%89%93%e9%80%a0%e5%ae%89%e5%85%a8%e7%9a%84%e8%b3%87%e6%96%99%e5%ad%98%e5%8f%96\/"},"modified":"2026-01-25T01:58:38","modified_gmt":"2026-01-24T17:58:38","slug":"%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9104-row-level-security-rls-%e6%89%93%e9%80%a0%e5%ae%89%e5%85%a8%e7%9a%84%e8%b3%87%e6%96%99%e5%ad%98%e5%8f%96","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9104-row-level-security-rls-%e6%89%93%e9%80%a0%e5%ae%89%e5%85%a8%e7%9a%84%e8%b3%87%e6%96%99%e5%ad%98%e5%8f%96\/","title":{"rendered":"\u3010Supabase \u6559\u5b78\u3011#04 Row Level Security (RLS) \u6253\u9020\u5b89\u5168\u7684\u8cc7\u6599\u5b58\u53d6"},"content":{"rendered":"\n<div id=\"quiz-basic\">\n<style>\n#quiz-basic .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-basic .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-basic .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-basic .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-basic .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-basic .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-basic .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-basic .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-basic .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-basic .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-basic .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-basic .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1aRow Level Security (RLS) \u6253\u9020\u5b89\u5168\u7684\u8cc7\u6599\u5b58\u53d6<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. Row Level Security (RLS) \u8207\u50b3\u7d71\u8cc7\u6599\u5eab\u6b0a\u9650\u7684\u4e3b\u8981\u5dee\u7570\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. RLS \u53ea\u80fd\u63a7\u5236\u8b80\u53d6\u6b0a\u9650\uff0c\u50b3\u7d71\u6b0a\u9650\u53ef\u4ee5\u63a7\u5236\u6240\u6709\u64cd\u4f5c<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u50b3\u7d71\u6b0a\u9650\u662f\u300c\u8868\u7d1a\u300d\u63a7\u5236\uff0cRLS \u662f\u300c\u884c\u7d1a\u300d\u63a7\u5236<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. RLS \u9700\u8981\u5f8c\u7aef\u4f3a\u670d\u5668\u652f\u63f4\uff0c\u50b3\u7d71\u6b0a\u9650\u4e0d\u9700\u8981<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u50b3\u7d71\u6b0a\u9650\u6548\u80fd\u8f03\u597d\uff0cRLS \u6703\u660e\u986f\u62d6\u6162\u67e5\u8a62\u901f\u5ea6<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u5728 Supabase \u4e2d\uff0c\u70ba\u4ec0\u9ebc RLS \u7279\u5225\u91cd\u8981\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u56e0\u70ba Supabase \u4e0d\u652f\u63f4\u4f7f\u7528\u8005\u9a57\u8b49\u529f\u80fd<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u56e0\u70ba PostgreSQL \u672c\u8eab\u6c92\u6709\u4efb\u4f55\u5b89\u5168\u6a5f\u5236<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u56e0\u70ba Supabase \u63a1\u7528\u524d\u7aef\u76f4\u9023\u8cc7\u6599\u5eab\u7684\u67b6\u69cb\uff0c\u6c92\u6709\u5f8c\u7aef\u4f3a\u670d\u5668\u904e\u6ffe\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u56e0\u70ba Supabase \u7684 anon key \u662f\u52a0\u5bc6\u7684\uff0c\u9700\u8981 RLS \u89e3\u5bc6<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5728 RLS Policy \u4e2d\uff0c<code>USING<\/code> \u548c <code>WITH CHECK<\/code> \u5404\u81ea\u7684\u7528\u9014\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'A')\">A. <code>USING<\/code> \u63a7\u5236\u8b80\u53d6\u6642\u7684\u689d\u4ef6\uff0c<code>WITH CHECK<\/code> \u63a7\u5236\u5beb\u5165\u6642\u7684\u689d\u4ef6<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'A')\">B. <code>USING<\/code> \u7528\u65bc INSERT\uff0c<code>WITH CHECK<\/code> \u7528\u65bc SELECT<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'A')\">C. \u5169\u8005\u529f\u80fd\u76f8\u540c\uff0c\u53ea\u662f\u5beb\u6cd5\u4e0d\u540c<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'A')\">D. <code>USING<\/code> \u7528\u65bc\u7ba1\u7406\u54e1\uff0c<code>WITH CHECK<\/code> \u7528\u65bc\u4e00\u822c\u4f7f\u7528\u8005<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u7576\u4f7f\u7528\u8005\u672a\u767b\u5165\u6642\uff0c<code>auth.uid()<\/code> \u51fd\u5f0f\u6703\u56de\u50b3\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'B')\">A. \u4e00\u500b\u7a7a\u5b57\u4e32 &#8220;&#8221;<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'B')\">B. null<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'B')\">C. \u62cb\u51fa\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'B')\">D. \u4e00\u500b\u9810\u8a2d\u7684\u533f\u540d UUID<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u555f\u7528 RLS \u5f8c\uff0c\u5982\u679c\u6c92\u6709\u5efa\u7acb\u4efb\u4f55 Policy\uff0c\u6703\u767c\u751f\u4ec0\u9ebc\u60c5\u6cc1\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'D')\">A. \u6240\u6709\u4eba\u90fd\u53ef\u4ee5\u5b58\u53d6\u6240\u6709\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'D')\">B. \u53ea\u6709\u7ba1\u7406\u54e1\u53ef\u4ee5\u5b58\u53d6\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'D')\">C. \u7cfb\u7d71\u6703\u81ea\u52d5\u5efa\u7acb\u9810\u8a2d\u7684 Policy<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'D')\">D. \u6240\u6709\u4eba\u90fd\u7121\u6cd5\u5b58\u53d6\u8cc7\u6599<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"\u50b3\u7d71\u8cc7\u6599\u5eab\u6b0a\u9650\u662f\u5728\u300c\u8868\u300d\u7684\u5c64\u7d1a\u63a7\u5236\uff08\u4f8b\u5982\uff1a\u4f7f\u7528\u8005 A \u53ef\u4ee5\u8b80\u53d6 posts \u8868\uff09\uff0c\u6240\u6709\u6709\u6b0a\u9650\u7684\u4eba\u90fd\u80fd\u770b\u5230\u8868\u5167\u6240\u6709\u8cc7\u6599\u3002\u800c RLS \u662f\u5728\u300c\u884c\u300d\u7684\u5c64\u7d1a\u63a7\u5236\uff0c\u53ef\u4ee5\u8b93\u4e0d\u540c\u4f7f\u7528\u8005\u53ea\u770b\u5230\u7279\u5b9a\u7684\u8cc7\u6599\u5217\uff08\u4f8b\u5982\uff1a\u4f7f\u7528\u8005 A \u53ea\u80fd\u770b\u5230\u81ea\u5df1\u7684\u6587\u7ae0\uff09\u3002\",\n        2: \"Supabase \u7684\u67b6\u69cb\u662f\u524d\u7aef\u76f4\u9023\u8cc7\u6599\u5eab\uff08\u700f\u89bd\u5668 -> Supabase Client -> PostgREST API -> PostgreSQL\uff09\uff0c\u6c92\u6709\u5f8c\u7aef\u4f3a\u670d\u5668\u5e6b\u5fd9\u904e\u6ffe\u8cc7\u6599\u3002\u7531\u65bc\u524d\u7aef\u7a0b\u5f0f\u78bc\u548c anon key \u90fd\u662f\u516c\u958b\u7684\uff0c\u5982\u679c\u6c92\u6709 RLS\uff0c\u60e1\u610f\u4f7f\u7528\u8005\u53ef\u4ee5\u76f4\u63a5\u67e5\u8a62\u6240\u6709\u8cc7\u6599\u3002\",\n        3: \"<code>USING<\/code> \u7528\u65bc\u63a7\u5236\u8b80\u53d6\u64cd\u4f5c\uff08SELECT\u3001UPDATE\u3001DELETE\uff09\u6642\u7684\u689d\u4ef6\u5224\u65b7\uff0c\u6c7a\u5b9a\u54ea\u4e9b\u8cc7\u6599\u5217\u53ef\u4ee5\u88ab\u8b80\u53d6\u3002<code>WITH CHECK<\/code> \u5247\u7528\u65bc\u63a7\u5236\u5beb\u5165\u64cd\u4f5c\uff08INSERT\u3001UPDATE\uff09\u6642\u7684\u689d\u4ef6\uff0c\u6c7a\u5b9a\u4ec0\u9ebc\u6a23\u7684\u8cc7\u6599\u53ef\u4ee5\u88ab\u5beb\u5165\u3002\",\n        4: \"\u7576\u4f7f\u7528\u8005\u672a\u767b\u5165\uff08\u4f7f\u7528 anon key\uff09\u6642\uff0c<code>auth.uid()<\/code> \u6703\u56de\u50b3 <code>null<\/code>\u3002\u9019\u500b\u7279\u6027\u5f88\u91cd\u8981\uff0c\u56e0\u70ba\u5728\u8a2d\u8a08 Policy \u6642\u9700\u8981\u8003\u616e\u5230\u672a\u767b\u5165\u4f7f\u7528\u8005\u7684\u60c5\u6cc1\uff0c\u901a\u5e38\u6703\u7528 <code>auth.uid() = user_id<\/code> \u9019\u6a23\u7684\u689d\u4ef6\u4f86\u9650\u5236\u5b58\u53d6\u3002\",\n        5: \"\u9019\u662f RLS \u7684\u9810\u8a2d\u5b89\u5168\u884c\u70ba\uff1a\u555f\u7528 RLS \u5f8c\uff0c\u5982\u679c\u6c92\u6709\u5efa\u7acb\u4efb\u4f55 Policy\uff0c\u6240\u6709\u67e5\u8a62\u90fd\u6703\u88ab\u62d2\u7d55\uff08\u56de\u50b3\u7a7a\u9663\u5217\uff09\u3002\u9019\u7a2e\u300c\u9810\u8a2d\u62d2\u7d55\u300d\u7684\u8a2d\u8a08\u662f\u70ba\u4e86\u78ba\u4fdd\u5b89\u5168\u6027\uff0c\u907f\u514d\u5fd8\u8a18\u8a2d\u5b9a Policy \u800c\u610f\u5916\u66b4\u9732\u8cc7\u6599\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u8a00<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u524d\u5e7e\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5b78\u6703\u4e86\u5982\u4f55\u4f7f\u7528 Supabase \u9032\u884c CRUD \u64cd\u4f5c\u548c\u4f7f\u7528\u8005\u9a57\u8b49\u3002\u4f46\u4f60\u6709\u6c92\u6709\u60f3\u904e\u4e00\u500b\u554f\u984c\uff1a\u65e2\u7136\u524d\u7aef\u53ef\u4ee5\u76f4\u63a5\u9023\u63a5\u8cc7\u6599\u5eab\uff0c\u90a3\u8c48\u4e0d\u662f\u4efb\u4f55\u4eba\u90fd\u80fd\u5b58\u53d6\u6240\u6709\u8cc7\u6599\uff1f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u6b63\u662f Row Level Security\uff08RLS\uff09\u8981\u89e3\u6c7a\u7684\u554f\u984c\u3002RLS \u662f PostgreSQL \u5167\u5efa\u7684\u5b89\u5168\u6a5f\u5236\uff0c\u8b93\u4f60\u80fd\u5728\u8cc7\u6599\u5eab\u5c64\u7d1a\u63a7\u5236\u300c\u8ab0\u53ef\u4ee5\u770b\u5230\u54ea\u4e9b\u8cc7\u6599\u300d\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b78\u7fd2\u76ee\u6a19<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u672c\u7bc7\u5f8c\uff0c\u4f60\u5c07\u80fd\u5920\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7406\u89e3 RLS \u7684\u904b\u4f5c\u539f\u7406\u8207\u91cd\u8981\u6027<\/li>\n<li>\u64b0\u5beb RLS Policy \u4f86\u63a7\u5236\u8cc7\u6599\u5b58\u53d6<\/li>\n<li>\u5be6\u4f5c\u5e38\u898b\u7684 RLS \u60c5\u5883\uff08\u81ea\u5df1\u7684\u8cc7\u6599\u3001\u89d2\u8272\u6b0a\u9650\uff09<\/li>\n<li>\u9664\u932f RLS Policy \u554f\u984c<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u4ec0\u9ebc\u662f Row Level Security<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Row Level Security\uff08\u884c\u7d1a\u5b89\u5168\u6027\uff09\u662f\u4e00\u7a2e\u8cc7\u6599\u5eab\u5b89\u5168\u6a5f\u5236\uff0c\u8b93\u4f60\u53ef\u4ee5\u63a7\u5236\u300c\u6bcf\u4e00\u884c\u8cc7\u6599\u300d\u7684\u5b58\u53d6\u6b0a\u9650\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u50b3\u7d71\u6b0a\u9650 vs RLS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u50b3\u7d71\u7684\u8cc7\u6599\u5eab\u6b0a\u9650\u662f\u300c\u8868\u7d1a\u300d\u7684\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u4f7f\u7528\u8005 A \u2192 \u53ef\u4ee5\u8b80\u53d6 posts \u8868 \u2192 \u770b\u5230\u6240\u6709\u6587\u7ae0\n\u4f7f\u7528\u8005 B \u2192 \u53ef\u4ee5\u8b80\u53d6 posts \u8868 \u2192 \u770b\u5230\u6240\u6709\u6587\u7ae0\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6709\u4e86 RLS \u5f8c\u8b8a\u6210\u300c\u884c\u7d1a\u300d\u7684\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u4f7f\u7528\u8005 A \u2192 \u53ef\u4ee5\u8b80\u53d6 posts \u8868 \u2192 \u53ea\u770b\u5230\u81ea\u5df1\u7684\u6587\u7ae0\n\u4f7f\u7528\u8005 B \u2192 \u53ef\u4ee5\u8b80\u53d6 posts \u8868 \u2192 \u53ea\u770b\u5230\u81ea\u5df1\u7684\u6587\u7ae0\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc Supabase \u7279\u5225\u9700\u8981 RLS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase \u7684\u67b6\u69cb\u662f\u300c\u524d\u7aef\u76f4\u9023\u8cc7\u6599\u5eab\u300d\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u700f\u89bd\u5668 \u2192 Supabase Client \u2192 PostgREST API \u2192 PostgreSQL\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u610f\u5473\u8457\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u524d\u7aef\u7a0b\u5f0f\u78bc\u662f\u516c\u958b\u7684\uff0c\u4efb\u4f55\u4eba\u90fd\u80fd\u770b\u5230<\/li>\n<li><code>anon key<\/code> \u4e5f\u662f\u516c\u958b\u7684\uff08\u5b83\u672c\u4f86\u5c31\u8a2d\u8a08\u6210\u53ef\u4ee5\u516c\u958b\uff09<\/li>\n<li>\u6c92\u6709\u5f8c\u7aef\u4f3a\u670d\u5668\u5e6b\u4f60\u904e\u6ffe\u8cc7\u6599<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u6c92\u6709 RLS\uff0c\u60e1\u610f\u4f7f\u7528\u8005\u53ef\u4ee5\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u60e1\u610f\u67e5\u8a62 - \u53d6\u5f97\u6240\u6709\u4f7f\u7528\u8005\u7684\u8cc7\u6599<\/span>\n<span class=\"hljs-keyword\">const<\/span> { data } = <span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'profiles'<\/span>).select(<span class=\"hljs-string\">'*'<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6709\u4e86 RLS\uff0c\u540c\u6a23\u7684\u67e5\u8a62\u6703\u81ea\u52d5\u88ab\u904e\u6ffe\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u540c\u6a23\u7684\u67e5\u8a62\uff0c\u4f46 RLS \u6703\u81ea\u52d5\u9650\u5236\u7d50\u679c<\/span>\n<span class=\"hljs-keyword\">const<\/span> { data } = <span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'profiles'<\/span>).select(<span class=\"hljs-string\">'*'<\/span>)\n<span class=\"hljs-comment\">\/\/ \u53ea\u6703\u56de\u50b3\u7576\u524d\u4f7f\u7528\u8005\u6709\u6b0a\u9650\u770b\u5230\u7684\u8cc7\u6599<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u555f\u7528 RLS \u8207\u5efa\u7acb Policy<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u7b2c\u4e00\u6b65\uff1a\u555f\u7528 RLS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 Supabase Dashboard \u7684 SQL Editor \u57f7\u884c\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">-- \u5c0d profiles \u8868\u555f\u7528 RLS\nALTER TABLE profiles ENABLE ROW LEVEL SECURITY;\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u91cd\u8981\u63d0\u9192\uff1a\u555f\u7528 RLS \u5f8c\uff0c\u5982\u679c\u6c92\u6709\u5efa\u7acb\u4efb\u4f55 Policy\uff0c\u6240\u6709\u4eba\u90fd\u7121\u6cd5\u5b58\u53d6\u8cc7\u6599\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7b2c\u4e8c\u6b65\uff1a\u5efa\u7acb Policy<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Policy \u5c31\u662f\u5b9a\u7fa9\u300c\u8ab0\u53ef\u4ee5\u5c0d\u54ea\u4e9b\u8cc7\u6599\u505a\u4ec0\u9ebc\u64cd\u4f5c\u300d\u7684\u898f\u5247\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u57fa\u672c\u8a9e\u6cd5\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">CREATE POLICY <span class=\"hljs-string\">\"policy_name\"<\/span>\nON table_name\nFOR operation\nTO role\nUSING (condition)\nWITH CHECK (condition);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u8b93\u6211\u5011\u9010\u4e00\u89e3\u6790\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u90e8\u5206<\/th>\n<th>\u8aaa\u660e<\/th>\n<th>\u7bc4\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>policy_name<\/code><\/td>\n<td>Policy \u7684\u540d\u7a31\uff0c\u65b9\u4fbf\u8b58\u5225<\/td>\n<td>&#8220;Users can view own profile&#8221;<\/td>\n<\/tr>\n<tr>\n<td><code>table_name<\/code><\/td>\n<td>\u8981\u5957\u7528\u7684\u8868<\/td>\n<td>profiles<\/td>\n<\/tr>\n<tr>\n<td><code>FOR operation<\/code><\/td>\n<td>\u64cd\u4f5c\u985e\u578b<\/td>\n<td>SELECT \/ INSERT \/ UPDATE \/ DELETE \/ ALL<\/td>\n<\/tr>\n<tr>\n<td><code>TO role<\/code><\/td>\n<td>\u5957\u7528\u5c0d\u8c61<\/td>\n<td>authenticated \/ anon \/ public<\/td>\n<\/tr>\n<tr>\n<td><code>USING<\/code><\/td>\n<td>\u8b80\u53d6\u6642\u7684\u689d\u4ef6\uff08SELECT, UPDATE, DELETE\uff09<\/td>\n<td><code>auth.uid() = user_id<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>WITH CHECK<\/code><\/td>\n<td>\u5beb\u5165\u6642\u7684\u689d\u4ef6\uff08INSERT, UPDATE\uff09<\/td>\n<td><code>auth.uid() = user_id<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u5be6\u969b\u7bc4\u4f8b\uff1a\u4f7f\u7528\u8005\u53ea\u80fd\u8b80\u5beb\u81ea\u5df1\u7684 Profile<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u555f\u7528 RLS\nALTER TABLE profiles ENABLE ROW LEVEL SECURITY;\n\n-- \u4f7f\u7528\u8005\u53ef\u4ee5\u8b80\u53d6\u81ea\u5df1\u7684 profile\nCREATE POLICY <span class=\"hljs-string\">\"Users can view own profile\"<\/span>\nON profiles\nFOR SELECT\nTO authenticated\nUSING (auth.uid() = user_id);\n\n-- \u4f7f\u7528\u8005\u53ef\u4ee5\u66f4\u65b0\u81ea\u5df1\u7684 profile\nCREATE POLICY <span class=\"hljs-string\">\"Users can update own profile\"<\/span>\nON profiles\nFOR UPDATE\nTO authenticated\nUSING (auth.uid() = user_id)\nWITH CHECK (auth.uid() = user_id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u8a8d\u8b58 auth.uid()<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>auth.uid()<\/code> \u662f Supabase \u63d0\u4f9b\u7684\u51fd\u5f0f\uff0c\u56de\u50b3\u7576\u524d\u767b\u5165\u4f7f\u7528\u8005\u7684 UUID\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u9019\u500b\u51fd\u5f0f\u6703\u56de\u50b3\u985e\u4f3c\u9019\u6a23\u7684\u503c\n-- <span class=\"hljs-string\">'123e4567-e89b-12d3-a456-426614174000'<\/span>\nSELECT auth.uid();\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u4f7f\u7528 Supabase Client \u767b\u5165\u5f8c\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u767b\u5165<\/span>\n<span class=\"hljs-keyword\">await<\/span> supabase.auth.signInWithPassword({\n  <span class=\"hljs-attr\">email<\/span>: <span class=\"hljs-string\">'user@example.com'<\/span>,\n  <span class=\"hljs-attr\">password<\/span>: <span class=\"hljs-string\">'password'<\/span>\n})\n\n<span class=\"hljs-comment\">\/\/ \u4e4b\u5f8c\u7684\u6240\u6709\u67e5\u8a62\uff0cauth.uid() \u90fd\u6703\u81ea\u52d5\u5e36\u5165\u9019\u500b\u4f7f\u7528\u8005\u7684 ID<\/span>\n<span class=\"hljs-keyword\">const<\/span> { data } = <span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'profiles'<\/span>).select(<span class=\"hljs-string\">'*'<\/span>)\n<span class=\"hljs-comment\">\/\/ RLS \u6703\u7528 auth.uid() \u4f86\u5224\u65b7\u9019\u500b\u4f7f\u7528\u8005\u80fd\u770b\u5230\u54ea\u4e9b\u8cc7\u6599<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u4f7f\u7528\u8005\u672a\u767b\u5165\uff08\u4f7f\u7528 anon key\uff09\uff0c<code>auth.uid()<\/code> \u6703\u56de\u50b3 <code>null<\/code>\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5e38\u898b Policy \u6a21\u5f0f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6a21\u5f0f\u4e00\uff1a\u53ea\u80fd\u8b80\u5beb\u81ea\u5df1\u7684\u8cc7\u6599<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f\u6700\u5e38\u898b\u7684\u6a21\u5f0f\uff0c\u9069\u7528\u65bc\u500b\u4eba\u8cc7\u6599\u3001\u79c1\u4eba\u7b46\u8a18\u7b49\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">-- \u8868\u7d50\u69cb\nCREATE TABLE notes (\n  id UUID PRIMARY KEY <span class=\"hljs-keyword\">DEFAULT<\/span> uuid_generate_v4(),\n  user_id UUID REFERENCES auth.users(id),\n  title TEXT,\n  content TEXT,\n  created_at TIMESTAMP <span class=\"hljs-keyword\">DEFAULT<\/span> NOW()\n);\n\n-- \u555f\u7528 RLS\nALTER TABLE notes ENABLE ROW LEVEL SECURITY;\n\n-- \u8b80\u53d6\u81ea\u5df1\u7684\u7b46\u8a18\nCREATE POLICY <span class=\"hljs-string\">\"Users can read own notes\"<\/span>\nON notes <span class=\"hljs-keyword\">FOR<\/span> SELECT\nTO authenticated\nUSING (auth.uid() = user_id);\n\n-- \u5efa\u7acb\u7b46\u8a18\u6642\u81ea\u52d5\u8a2d\u5b9a user_id\nCREATE POLICY <span class=\"hljs-string\">\"Users can create own notes\"<\/span>\nON notes <span class=\"hljs-keyword\">FOR<\/span> INSERT\nTO authenticated\nWITH CHECK (auth.uid() = user_id);\n\n-- \u66f4\u65b0\u81ea\u5df1\u7684\u7b46\u8a18\nCREATE POLICY <span class=\"hljs-string\">\"Users can update own notes\"<\/span>\nON notes <span class=\"hljs-keyword\">FOR<\/span> UPDATE\nTO authenticated\nUSING (auth.uid() = user_id)\nWITH CHECK (auth.uid() = user_id);\n\n-- \u522a\u9664\u81ea\u5df1\u7684\u7b46\u8a18\nCREATE POLICY <span class=\"hljs-string\">\"Users can delete own notes\"<\/span>\nON notes <span class=\"hljs-keyword\">FOR<\/span> DELETE\nTO authenticated\nUSING (auth.uid() = user_id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6a21\u5f0f\u4e8c\uff1a\u516c\u958b\u53ef\u8b80\u3001\u767b\u5165\u624d\u80fd\u5beb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9069\u7528\u65bc\u90e8\u843d\u683c\u6587\u7ae0\u3001\u516c\u958b\u7559\u8a00\u7b49\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">-- \u8868\u7d50\u69cb\nCREATE TABLE posts (\n  id UUID PRIMARY KEY <span class=\"hljs-keyword\">DEFAULT<\/span> uuid_generate_v4(),\n  author_id UUID REFERENCES auth.users(id),\n  title TEXT,\n  content TEXT,\n  published BOOLEAN <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">false<\/span>,\n  created_at TIMESTAMP <span class=\"hljs-keyword\">DEFAULT<\/span> NOW()\n);\n\n-- \u555f\u7528 RLS\nALTER TABLE posts ENABLE ROW LEVEL SECURITY;\n\n-- \u4efb\u4f55\u4eba\u90fd\u53ef\u4ee5\u8b80\u53d6\u5df2\u767c\u5e03\u7684\u6587\u7ae0\nCREATE POLICY <span class=\"hljs-string\">\"Anyone can read published posts\"<\/span>\nON posts <span class=\"hljs-keyword\">FOR<\/span> SELECT\nTO anon, authenticated\nUSING (published = <span class=\"hljs-keyword\">true<\/span>);\n\n-- \u4f5c\u8005\u53ef\u4ee5\u8b80\u53d6\u81ea\u5df1\u6240\u6709\u7684\u6587\u7ae0\uff08\u5305\u542b\u672a\u767c\u5e03\uff09\nCREATE POLICY <span class=\"hljs-string\">\"Authors can read own posts\"<\/span>\nON posts <span class=\"hljs-keyword\">FOR<\/span> SELECT\nTO authenticated\nUSING (auth.uid() = author_id);\n\n-- \u767b\u5165\u4f7f\u7528\u8005\u53ef\u4ee5\u5efa\u7acb\u6587\u7ae0\nCREATE POLICY <span class=\"hljs-string\">\"Authenticated users can create posts\"<\/span>\nON posts <span class=\"hljs-keyword\">FOR<\/span> INSERT\nTO authenticated\nWITH CHECK (auth.uid() = author_id);\n\n-- \u4f5c\u8005\u53ef\u4ee5\u66f4\u65b0\u81ea\u5df1\u7684\u6587\u7ae0\nCREATE POLICY <span class=\"hljs-string\">\"Authors can update own posts\"<\/span>\nON posts <span class=\"hljs-keyword\">FOR<\/span> UPDATE\nTO authenticated\nUSING (auth.uid() = author_id)\nWITH CHECK (auth.uid() = author_id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6a21\u5f0f\u4e09\uff1a\u89d2\u8272\u578b\u6b0a\u9650\u63a7\u5236<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9069\u7528\u65bc\u6709\u7ba1\u7406\u54e1\u3001\u4e00\u822c\u4f7f\u7528\u8005\u7b49\u4e0d\u540c\u89d2\u8272\u7684\u7cfb\u7d71\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9996\u5148\uff0c\u5728 profiles \u8868\u52a0\u5165\u89d2\u8272\u6b04\u4f4d\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u5047\u8a2d profiles \u8868\u6709 role \u6b04\u4f4d\n-- role \u53ef\u80fd\u662f <span class=\"hljs-string\">'admin'<\/span>, <span class=\"hljs-string\">'moderator'<\/span>, <span class=\"hljs-string\">'user'<\/span>\n\n-- \u7ba1\u7406\u54e1\u53ef\u4ee5\u8b80\u53d6\u6240\u6709\u4f7f\u7528\u8005\u8cc7\u6599\nCREATE POLICY <span class=\"hljs-string\">\"Admins can read all profiles\"<\/span>\nON profiles FOR SELECT\nTO authenticated\nUSING (\n  EXISTS (\n    SELECT <span class=\"hljs-number\">1<\/span> FROM profiles\n    WHERE user_id = auth.uid()\n    AND role = <span class=\"hljs-string\">'admin'<\/span>\n  )\n);\n\n-- \u4e00\u822c\u4f7f\u7528\u8005\u53ea\u80fd\u8b80\u53d6\u81ea\u5df1\u7684\u8cc7\u6599\nCREATE POLICY <span class=\"hljs-string\">\"Users can read own profile\"<\/span>\nON profiles FOR SELECT\nTO authenticated\nUSING (auth.uid() = user_id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u66f4\u7c21\u6f54\u7684\u5beb\u6cd5\uff0c\u4f7f\u7528\u81ea\u8a02\u51fd\u5f0f\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u5efa\u7acb\u6aa2\u67e5\u89d2\u8272\u7684\u51fd\u5f0f\nCREATE OR REPLACE FUNCTION is_admin()\nRETURNS BOOLEAN AS $$\n  SELECT EXISTS (\n    SELECT <span class=\"hljs-number\">1<\/span> FROM profiles\n    WHERE user_id = auth.uid()\n    AND role = <span class=\"hljs-string\">'admin'<\/span>\n  );\n$$ LANGUAGE sql SECURITY DEFINER;\n\n-- \u4f7f\u7528\u51fd\u5f0f\u7c21\u5316 Policy\nCREATE POLICY <span class=\"hljs-string\">\"Admins can do everything\"<\/span>\nON posts FOR ALL\nTO authenticated\nUSING (is_admin() OR auth.uid() = author_id)\nWITH CHECK (is_admin() OR auth.uid() = author_id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u4f7f\u7528 Dashboard \u6e2c\u8a66 Policy<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase Dashboard \u63d0\u4f9b\u4e86\u65b9\u4fbf\u7684\u5de5\u5177\u4f86\u6e2c\u8a66 RLS Policy\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u6cd5\u4e00\uff1aSQL Editor \u6a21\u64ec\u4f7f\u7528\u8005<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u8a2d\u5b9a\u8981\u6a21\u64ec\u7684\u4f7f\u7528\u8005\uff08\u4f7f\u7528\u5be6\u969b\u7684 user UUID\uff09\nSET LOCAL ROLE authenticated;\nSET LOCAL request.jwt.claims = <span class=\"hljs-string\">'{\"sub\": \"user-uuid-here\"}'<\/span>;\n\n-- \u57f7\u884c\u67e5\u8a62\u770b\u7d50\u679c\nSELECT * FROM profiles;\n\n-- \u91cd\u8a2d\nRESET ROLE;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u6cd5\u4e8c\uff1aTable Editor \u7684 RLS \u8996\u5716<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u524d\u5f80 Table Editor<\/li>\n<li>\u9078\u64c7\u4f60\u7684\u8868<\/li>\n<li>\u9ede\u64ca\u53f3\u4e0a\u89d2\u7684\u300cRLS\u300d\u6309\u9215<\/li>\n<li>\u53ef\u4ee5\u770b\u5230\u8a72\u8868\u7684\u6240\u6709 Policy<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u6cd5\u4e09\uff1a\u4f7f\u7528 API \u5be6\u969b\u6e2c\u8a66<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u6e2c\u8a66\u672a\u767b\u5165\u72c0\u614b<\/span>\n<span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: anonData } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n<span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">'Anonymous:'<\/span>, anonData)\n\n<span class=\"hljs-comment\">\/\/ \u6e2c\u8a66\u767b\u5165\u72c0\u614b<\/span>\n<span class=\"hljs-keyword\">await<\/span> supabase.auth.signInWithPassword({\n  <span class=\"hljs-attr\">email<\/span>: <span class=\"hljs-string\">'test@example.com'<\/span>,\n  <span class=\"hljs-attr\">password<\/span>: <span class=\"hljs-string\">'password'<\/span>\n})\n\n<span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: authData } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n<span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">'Authenticated:'<\/span>, authData)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">RLS \u5e38\u898b\u554f\u984c\u8207\u9664\u932f\u6280\u5de7<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u554f\u984c\u4e00\uff1a\u555f\u7528 RLS \u5f8c\u6240\u6709\u67e5\u8a62\u90fd\u56de\u50b3\u7a7a\u9663\u5217<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u539f\u56e0\uff1a\u555f\u7528 RLS \u4f46\u6c92\u6709\u5efa\u7acb\u4efb\u4f55 Policy\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u6c7a\uff1a\u78ba\u8a8d\u5df2\u5efa\u7acb\u5c0d\u61c9\u7684 Policy\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u6aa2\u67e5\u8868\u7684 Policy\nSELECT * FROM pg_policies WHERE tablename = <span class=\"hljs-string\">'your_table'<\/span>;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u554f\u984c\u4e8c\uff1aPolicy \u5beb\u5c0d\u4e86\u4f46\u9084\u662f\u7121\u6cd5\u5b58\u53d6<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ef\u80fd\u539f\u56e0\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u4f7f\u7528\u8005\u7684 <code>user_id<\/code> \u6b04\u4f4d\u503c\u4e0d\u6b63\u78ba<\/li>\n<li>Policy \u7684 <code>TO<\/code> \u89d2\u8272\u8a2d\u5b9a\u932f\u8aa4<\/li>\n<li>\u67e5\u8a62\u6642\u672a\u767b\u5165\uff08<code>auth.uid()<\/code> \u70ba null\uff09<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u9664\u932f\u6b65\u9a5f\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- <span class=\"hljs-number\">1.<\/span> \u78ba\u8a8d\u8868\u7684 RLS \u72c0\u614b\nSELECT relname, relrowsecurity\nFROM pg_class\nWHERE relname = <span class=\"hljs-string\">'your_table'<\/span>;\n\n-- <span class=\"hljs-number\">2.<\/span> \u5217\u51fa\u6240\u6709 Policy\nSELECT * FROM pg_policies WHERE tablename = <span class=\"hljs-string\">'your_table'<\/span>;\n\n-- <span class=\"hljs-number\">3.<\/span> \u78ba\u8a8d\u8cc7\u6599\u7684 user_id\nSELECT id, user_id FROM your_table LIMIT <span class=\"hljs-number\">10<\/span>;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u554f\u984c\u4e09\uff1aINSERT \u5931\u6557\u4f46 SELECT \u6b63\u5e38<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u539f\u56e0\uff1a<code>WITH CHECK<\/code> \u689d\u4ef6\u672a\u901a\u904e\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5e38\u898b\u932f\u8aa4\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u932f\u8aa4\uff1a\u6c92\u6709\u50b3\u5165 user_id<\/span>\n<span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'notes'<\/span>).insert({ <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'Test'<\/span> })\n\n<span class=\"hljs-comment\">\/\/ \u6b63\u78ba\uff1a\u660e\u78ba\u50b3\u5165 user_id<\/span>\n<span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n<span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'notes'<\/span>).insert({\n  <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'Test'<\/span>,\n  <span class=\"hljs-attr\">user_id<\/span>: user.id\n})\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u554f\u984c\u56db\uff1a\u60f3\u66ab\u6642\u7e5e\u904e RLS \u9032\u884c\u7dad\u8b77<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 Dashboard \u7684 SQL Editor \u4e2d\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">-- Service Role \u6703\u7e5e\u904e RLS\n-- Dashboard \u7684 SQL Editor \u9810\u8a2d\u5c31\u662f\u7528 Service Role\n\n-- \u6216\u8005\u5728 Policy \u4e2d\u7279\u5225\u8655\u7406\n-- \uff08\u4e0d\u5efa\u8b70\u5728\u6b63\u5f0f\u74b0\u5883\u9019\u6a23\u505a\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5f8c\u7aef\u4f7f\u7528 Service Role Key\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">import<\/span> { createClient } <span class=\"hljs-keyword\">from<\/span> <span class=\"hljs-string\">'@supabase\/supabase-js'<\/span>\n\n<span class=\"hljs-keyword\">const<\/span> supabaseAdmin = createClient(\n  process.env.SUPABASE_URL,\n  process.env.SUPABASE_SERVICE_ROLE_KEY <span class=\"hljs-comment\">\/\/ \u9019\u500b key \u6703\u7e5e\u904e RLS<\/span>\n)\n\n<span class=\"hljs-comment\">\/\/ \u9019\u500b\u67e5\u8a62\u6703\u56de\u50b3\u6240\u6709\u8cc7\u6599<\/span>\n<span class=\"hljs-keyword\">const<\/span> { data } = <span class=\"hljs-keyword\">await<\/span> supabaseAdmin.from(<span class=\"hljs-string\">'profiles'<\/span>).select(<span class=\"hljs-string\">'*'<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6ce8\u610f\uff1aService Role Key \u7d55\u5c0d\u4e0d\u80fd\u66b4\u9732\u5728\u524d\u7aef\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Policy \u8a2d\u8a08\u7684\u6700\u4f73\u5be6\u8e10<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. \u547d\u540d\u8981\u6e05\u695a<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u597d\u7684\u547d\u540d\nCREATE POLICY <span class=\"hljs-string\">\"Users can read own notes\"<\/span> ...\nCREATE POLICY <span class=\"hljs-string\">\"Admins can delete any post\"<\/span> ...\n\n-- \u4e0d\u597d\u7684\u547d\u540d\nCREATE POLICY <span class=\"hljs-string\">\"policy1\"<\/span> ...\nCREATE POLICY <span class=\"hljs-string\">\"read_policy\"<\/span> ...\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">2. \u76e1\u91cf\u7cbe\u78ba\uff0c\u907f\u514d\u904e\u65bc\u5bec\u9b06<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u592a\u5bec\u9b06\uff08\u5371\u96aa\uff09\nCREATE POLICY <span class=\"hljs-string\">\"Anyone can do anything\"<\/span>\nON posts FOR ALL\nUSING (<span class=\"hljs-literal\">true<\/span>);\n\n-- \u7cbe\u78ba\u63a7\u5236\nCREATE POLICY <span class=\"hljs-string\">\"Authors can update own published posts\"<\/span>\nON posts FOR UPDATE\nTO authenticated\nUSING (auth.uid() = author_id AND published = <span class=\"hljs-literal\">true<\/span>);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">3. \u8003\u616e\u6548\u80fd<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Policy \u6703\u5728\u6bcf\u6b21\u67e5\u8a62\u6642\u57f7\u884c\uff0c\u8907\u96dc\u7684\u689d\u4ef6\u53ef\u80fd\u5f71\u97ff\u6548\u80fd\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">-- \u53ef\u80fd\u8f03\u6162\uff08\u5b50\u67e5\u8a62\uff09\nUSING (\n  EXISTS (\n    SELECT 1 FROM team_members\n    WHERE team_members.team_id = posts.team_id\n    AND team_members.user_id = auth.uid()\n  )\n)\n\n-- \u8f03\u5feb\uff08\u76f4\u63a5\u6bd4\u5c0d\uff09\nUSING (auth.uid() = user_id)\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u9700\u8981\u8907\u96dc\u908f\u8f2f\uff0c\u8003\u616e\u4f7f\u7528 <code>SECURITY DEFINER<\/code> \u51fd\u5f0f\u4e26\u5efa\u7acb\u9069\u7576\u7684\u7d22\u5f15\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5c0f\u7d50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u672c\u7bc7\u4ecb\u7d39\u4e86 Row Level Security \u7684\u6838\u5fc3\u6982\u5ff5\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>RLS \u662f\u4ec0\u9ebc<\/strong>\uff1a\u8cc7\u6599\u5eab\u5c64\u7d1a\u7684\u884c\u7d1a\u6b0a\u9650\u63a7\u5236<\/li>\n<li><strong>\u70ba\u4ec0\u9ebc\u91cd\u8981<\/strong>\uff1aSupabase \u524d\u7aef\u76f4\u9023\u67b6\u69cb\u7684\u5b89\u5168\u57fa\u790e<\/li>\n<li><strong>\u57fa\u672c\u8a9e\u6cd5<\/strong>\uff1a<code>USING<\/code> \u63a7\u5236\u8b80\u53d6\u3001<code>WITH CHECK<\/code> \u63a7\u5236\u5beb\u5165<\/li>\n<li><strong>\u5e38\u898b\u6a21\u5f0f<\/strong>\uff1a\u81ea\u5df1\u7684\u8cc7\u6599\u3001\u516c\u958b\u53ef\u8b80\u3001\u89d2\u8272\u6b0a\u9650<\/li>\n<li><strong>\u9664\u932f\u6280\u5de7<\/strong>\uff1a\u6aa2\u67e5 Policy\u3001\u78ba\u8a8d user_id\u3001\u4f7f\u7528 Dashboard \u6e2c\u8a66<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">RLS \u662f Supabase \u5b89\u5168\u6027\u7684\u6838\u5fc3\uff0c\u82b1\u6642\u9593\u7406\u89e3\u5b83\u7d55\u5c0d\u503c\u5f97\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e0b\u4e00\u6b65<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u4e0b\u4e00\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u5b78\u7fd2 Supabase \u7684 Realtime \u529f\u80fd\uff0c\u8b93\u4f60\u7684\u61c9\u7528\u7a0b\u5f0f\u80fd\u5373\u6642\u540c\u6b65\u8cc7\u6599\u66f4\u65b0\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u53c3\u8003\u8cc7\u6e90<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/supabase.com\/docs\/guides\/auth\/row-level-security\">Supabase RLS \u5b98\u65b9\u6587\u4ef6<\/a><\/li>\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/ddl-rowsecurity.html\">PostgreSQL RLS \u6587\u4ef6<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"quiz-advanced\">\n<style>\n#quiz-advanced .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-advanced .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-advanced .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-advanced .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-advanced .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-advanced .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-advanced .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-advanced .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-advanced .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-advanced .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-advanced .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-advanced .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-advanced .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-advanced .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-advanced .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-advanced .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-advanced .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1aRow Level Security (RLS) \u6253\u9020\u5b89\u5168\u7684\u8cc7\u6599\u5b58\u53d6<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b\u7b46\u8a18\u61c9\u7528\u7a0b\u5f0f\uff0c\u9700\u8981\u8b93\u4f7f\u7528\u8005\u53ea\u80fd\u8b80\u53d6\u548c\u7de8\u8f2f\u81ea\u5df1\u7684\u7b46\u8a18\u3002\u4ee5\u4e0b\u662f\u4f60\u7684\u8868\u7d50\u69cb\uff1a<span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">CREATE TABLE notes (\n  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),\n  user_id UUID REFERENCES auth.users(id),\n  title TEXT,\n  content TEXT\n);<\/div>\n      <p>\u4f60\u5df2\u7d93\u555f\u7528 RLS\uff0c\u73fe\u5728\u9700\u8981\u5efa\u7acb Policy\u3002\u4ee5\u4e0b\u54ea\u500b Policy \u8a2d\u8a08\u6700\u6b63\u78ba\u4e14\u5b8c\u6574\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'C')\">A. \u53ea\u9700\u8981\u4e00\u500b <code>FOR ALL USING (auth.uid() = user_id)<\/code> \u7684 Policy<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'C')\">B. \u5efa\u7acb SELECT \u548c UPDATE \u7684 Policy\uff0c\u689d\u4ef6\u90fd\u662f <code>USING (auth.uid() = user_id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'C')\">C. \u5206\u5225\u5efa\u7acb SELECT\u3001INSERT\u3001UPDATE\u3001DELETE \u7684 Policy\uff0c\u5176\u4e2d INSERT \u548c UPDATE \u9700\u8981\u540c\u6642\u6709 <code>USING<\/code> \u548c <code>WITH CHECK<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'C')\">D. \u53ea\u9700\u8981\u5efa\u7acb SELECT \u7684 Policy\uff0c\u5beb\u5165\u64cd\u4f5c\u4e0d\u9700\u8981\u984d\u5916\u7684 Policy<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u5c0f\u660e\u7684 INSERT \u64cd\u4f5c\u4e00\u76f4\u5931\u6557\uff0c\u4f46 SELECT \u6b63\u5e38\u904b\u4f5c\u3002\u4ed6\u7684\u7a0b\u5f0f\u78bc\u5982\u4e0b\uff1a<span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">\/\/ \u524d\u7aef\u7a0b\u5f0f\u78bc\nawait supabase.from(&#8216;notes&#8217;).insert({\n  title: &#8216;My Note&#8217;,\n  content: &#8216;Hello World&#8217;\n})\n\n\/\/ Policy\nCREATE POLICY &#8220;Users can create notes&#8221;\nON notes FOR INSERT\nTO authenticated\nWITH CHECK (auth.uid() = user_id);<\/div>\n      <p>\u6700\u53ef\u80fd\u7684\u554f\u984c\u662f\u4ec0\u9ebc\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'B')\">A. Policy \u8a9e\u6cd5\u932f\u8aa4\uff0cINSERT \u4e0d\u80fd\u4f7f\u7528 <code>WITH CHECK<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'B')\">B. INSERT \u6642\u6c92\u6709\u50b3\u5165 <code>user_id<\/code>\uff0c\u5c0e\u81f4 <code>WITH CHECK<\/code> \u689d\u4ef6\u7121\u6cd5\u901a\u904e<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'B')\">C. \u61c9\u8a72\u4f7f\u7528 <code>anon<\/code> \u89d2\u8272\u800c\u4e0d\u662f <code>authenticated<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'B')\">D. \u9700\u8981\u5148\u57f7\u884c <code>ALTER TABLE notes ENABLE ROW LEVEL SECURITY<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u9700\u8981\u8a2d\u8a08\u4e00\u500b\u90e8\u843d\u683c\u7cfb\u7d71\u7684 RLS Policy\uff0c\u9700\u6c42\u5982\u4e0b\uff1a<span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">\u9700\u6c42\uff1a\n&#8211; \u4efb\u4f55\u4eba\uff08\u5305\u542b\u672a\u767b\u5165\uff09\u90fd\u53ef\u4ee5\u95b1\u8b80\u300c\u5df2\u767c\u5e03\u300d\u7684\u6587\u7ae0\n&#8211; \u4f5c\u8005\u53ef\u4ee5\u95b1\u8b80\u81ea\u5df1\u6240\u6709\u7684\u6587\u7ae0\uff08\u5305\u542b\u672a\u767c\u5e03\uff09\n&#8211; \u53ea\u6709\u4f5c\u8005\u53ef\u4ee5\u7de8\u8f2f\u81ea\u5df1\u7684\u6587\u7ae0<\/div>\n      <p>\u4ee5\u4e0b\u54ea\u500b Policy \u7d44\u5408\u53ef\u4ee5\u6b63\u78ba\u5be6\u73fe\u9019\u4e9b\u9700\u6c42\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. \u4e00\u500b Policy\uff1a<code>FOR SELECT USING (published = true OR auth.uid() = author_id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. \u5169\u500b Policy\uff1a<code>FOR SELECT TO anon USING (published = true)<\/code> \u548c <code>FOR ALL TO authenticated USING (auth.uid() = author_id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. \u5169\u500b Policy\uff1a<code>FOR SELECT USING (true)<\/code> \u548c <code>FOR UPDATE USING (auth.uid() = author_id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. \u4e09\u500b Policy\uff1a<code>FOR SELECT TO anon, authenticated USING (published = true)<\/code>\u3001<code>FOR SELECT TO authenticated USING (auth.uid() = author_id)<\/code>\u3001<code>FOR UPDATE TO authenticated USING (auth.uid() = author_id)<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5c0f\u83ef\u555f\u7528\u4e86 RLS\uff0c\u4e5f\u5efa\u7acb\u4e86\u6b63\u78ba\u7684 Policy\uff0c\u4f46\u6240\u6709\u67e5\u8a62\u90fd\u56de\u50b3\u7a7a\u9663\u5217\u3002\u5979\u57f7\u884c\u4e86\u4ee5\u4e0b\u8a3a\u65b7\u6307\u4ee4\uff1a<span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">&#8212; \u6aa2\u67e5 Policy\nSELECT * FROM pg_policies WHERE tablename = &#8216;profiles&#8217;;\n\n&#8212; \u7d50\u679c\u986f\u793a Policy \u5b58\u5728\u4e14\u689d\u4ef6\u6b63\u78ba\n&#8212; Policy: USING (auth.uid() = user_id)\n\n&#8212; \u6aa2\u67e5\u8cc7\u6599\nSELECT id, user_id FROM profiles LIMIT 5;\n\n&#8212; \u7d50\u679c\uff1a\n&#8212; id: 1, user_id: NULL\n&#8212; id: 2, user_id: NULL\n&#8212; &#8230;<\/div>\n      <p>\u6839\u64da\u8a3a\u65b7\u7d50\u679c\uff0c\u6700\u53ef\u80fd\u7684\u539f\u56e0\u662f\u4ec0\u9ebc\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'C')\">A. <code>pg_policies<\/code> \u67e5\u8a62\u7d50\u679c\u6709\u8aa4\uff0cPolicy \u5176\u5be6\u6c92\u6709\u6b63\u78ba\u5efa\u7acb<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'C')\">B. \u4f7f\u7528\u8005\u6c92\u6709\u767b\u5165\uff0c<code>auth.uid()<\/code> \u56de\u50b3 null<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'C')\">C. \u8cc7\u6599\u8868\u4e2d\u7684 <code>user_id<\/code> \u6b04\u4f4d\u90fd\u662f NULL\uff0c\u7121\u6cd5\u8207 <code>auth.uid()<\/code> \u5339\u914d<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'C')\">D. \u9700\u8981\u91cd\u65b0\u555f\u7528 RLS \u624d\u80fd\u8b93 Policy \u751f\u6548<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b\u6709\u7ba1\u7406\u54e1\u548c\u4e00\u822c\u4f7f\u7528\u8005\u7684\u7cfb\u7d71\u3002\u4f60\u60f3\u8b93\u7ba1\u7406\u54e1\u53ef\u4ee5\u8b80\u53d6\u6240\u6709\u4f7f\u7528\u8005\u7684 profile\uff0c\u800c\u4e00\u822c\u4f7f\u7528\u8005\u53ea\u80fd\u8b80\u53d6\u81ea\u5df1\u7684\u3002\u4ee5\u4e0b\u662f\u4f60\u7684\u505a\u6cd5\uff1a<span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">&#8212; profiles \u8868\u6709 role \u6b04\u4f4d (&#8216;admin&#8217; \u6216 &#8216;user&#8217;)\n\nCREATE POLICY &#8220;Read profiles&#8221;\nON profiles FOR SELECT\nTO authenticated\nUSING (\n  auth.uid() = user_id\n  OR\n  (SELECT role FROM profiles WHERE user_id = auth.uid()) = &#8216;admin&#8217;\n);<\/div>\n      <p>\u9019\u500b\u505a\u6cd5\u6709\u4ec0\u9ebc\u6f5b\u5728\u554f\u984c\uff1f\u6700\u4f73\u7684\u6539\u9032\u65b9\u5f0f\u662f\u4ec0\u9ebc\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'B')\">A. \u8a9e\u6cd5\u932f\u8aa4\uff0cPolicy \u4e2d\u4e0d\u80fd\u4f7f\u7528\u5b50\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'B')\">B. \u6bcf\u6b21\u67e5\u8a62\u90fd\u6703\u57f7\u884c\u5b50\u67e5\u8a62\uff0c\u53ef\u80fd\u5f71\u97ff\u6548\u80fd\u3002\u5efa\u8b70\u4f7f\u7528 <code>SECURITY DEFINER<\/code> \u51fd\u5f0f\u4f86\u5c01\u88dd\u89d2\u8272\u6aa2\u67e5<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'B')\">C. \u7ba1\u7406\u54e1\u89d2\u8272\u6aa2\u67e5\u61c9\u8a72\u653e\u5728\u5f8c\u7aef\uff0c\u4e0d\u61c9\u8a72\u7528 RLS \u5be6\u73fe<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'B')\">D. \u5b8c\u5168\u6c92\u6709\u554f\u984c\uff0c\u9019\u662f\u6700\u4f73\u5be6\u8e10<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"\u5b8c\u6574\u7684 CRUD \u64cd\u4f5c\u9700\u8981\u5206\u5225\u5efa\u7acb\u5c0d\u61c9\u7684 Policy\u3002INSERT \u9700\u8981 <code>WITH CHECK<\/code> \u4f86\u9a57\u8b49\u65b0\u8cc7\u6599\uff0cUPDATE \u9700\u8981\u540c\u6642\u6709 <code>USING<\/code>\uff08\u6c7a\u5b9a\u53ef\u4ee5\u66f4\u65b0\u54ea\u4e9b\u73fe\u6709\u8cc7\u6599\uff09\u548c <code>WITH CHECK<\/code>\uff08\u9a57\u8b49\u66f4\u65b0\u5f8c\u7684\u8cc7\u6599\u662f\u5426\u5408\u6cd5\uff09\u3002\u53ea\u7528 <code>FOR ALL<\/code> \u96d6\u7136\u7c21\u6f54\uff0c\u4f46\u7121\u6cd5\u7cbe\u7d30\u63a7\u5236\u4e0d\u540c\u64cd\u4f5c\u7684\u689d\u4ef6\u3002\",\n        2: \"\u554f\u984c\u51fa\u5728\u524d\u7aef INSERT \u6642\u6c92\u6709\u50b3\u5165 <code>user_id<\/code>\u3002Policy \u7684 <code>WITH CHECK (auth.uid() = user_id)<\/code> \u6703\u6aa2\u67e5\u65b0\u63d2\u5165\u7684\u8cc7\u6599\u662f\u5426\u6eff\u8db3\u689d\u4ef6\uff0c\u4f46\u5982\u679c <code>user_id<\/code> \u662f null\uff08\u672a\u50b3\u5165\uff09\uff0c\u5247 <code>auth.uid() = null<\/code> \u6703\u662f false\uff0c\u5c0e\u81f4 INSERT \u5931\u6557\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u5728 INSERT \u6642\u660e\u78ba\u50b3\u5165 <code>user_id: user.id<\/code>\u3002\",\n        3: \"\u9078\u9805 D \u662f\u6b63\u78ba\u7684\u3002\u7b2c\u4e00\u500b Policy \u8b93\u6240\u6709\u4eba\u90fd\u80fd\u8b80\u53d6\u5df2\u767c\u5e03\u7684\u6587\u7ae0\uff0c\u7b2c\u4e8c\u500b Policy \u8b93\u5df2\u767b\u5165\u7684\u4f5c\u8005\u80fd\u8b80\u53d6\u81ea\u5df1\u7684\u6240\u6709\u6587\u7ae0\uff08OR \u908f\u8f2f\uff09\uff0c\u7b2c\u4e09\u500b Policy \u9650\u5236\u53ea\u6709\u4f5c\u8005\u80fd\u66f4\u65b0\u81ea\u5df1\u7684\u6587\u7ae0\u3002\u9078\u9805 A \u7f3a\u5c11 TO \u89d2\u8272\u6307\u5b9a\uff0c\u9078\u9805 B \u7684 <code>FOR ALL<\/code> \u6703\u8b93\u4f5c\u8005\u53ef\u4ee5\u5c0d\u81ea\u5df1\u7684\u6587\u7ae0\u505a\u4efb\u4f55\u64cd\u4f5c\uff08\u5305\u542b DELETE\uff09\uff0c\u9078\u9805 C \u7684 <code>USING (true)<\/code> \u6703\u8b93\u6240\u6709\u4eba\u8b80\u53d6\u6240\u6709\u6587\u7ae0\u3002\",\n        4: \"\u8a3a\u65b7\u7d50\u679c\u6e05\u695a\u986f\u793a <code>user_id<\/code> \u6b04\u4f4d\u90fd\u662f NULL\u3002\u7576 Policy \u689d\u4ef6\u662f <code>auth.uid() = user_id<\/code> \u6642\uff0c\u5373\u4f7f\u4f7f\u7528\u8005\u5df2\u767b\u5165\uff0c<code>auth.uid()<\/code> \u4e5f\u7121\u6cd5\u8207 NULL \u503c\u5339\u914d\uff08\u56e0\u70ba NULL = \u4efb\u4f55\u503c \u90fd\u662f NULL\/false\uff09\u3002\u89e3\u6c7a\u65b9\u6cd5\u662f\u78ba\u4fdd\u8cc7\u6599\u5728\u5efa\u7acb\u6642\u6b63\u78ba\u8a2d\u5b9a <code>user_id<\/code>\u3002\",\n        5: \"\u96d6\u7136\u5728 Policy \u4e2d\u4f7f\u7528\u5b50\u67e5\u8a62\u662f\u5408\u6cd5\u7684\uff0c\u4f46\u6bcf\u6b21\u67e5\u8a62\u90fd\u6703\u57f7\u884c\u9019\u500b\u5b50\u67e5\u8a62\uff0c\u5728\u5927\u91cf\u8cc7\u6599\u6642\u6703\u5f71\u97ff\u6548\u80fd\u3002\u6587\u7ae0\u4e2d\u5efa\u8b70\u7684\u6700\u4f73\u5be6\u8e10\u662f\u5efa\u7acb\u4e00\u500b <code>SECURITY DEFINER<\/code> \u51fd\u5f0f\uff08\u5982 <code>is_admin()<\/code>\uff09\uff0c\u9019\u6a23\u53ef\u4ee5\u66f4\u597d\u5730\u5c01\u88dd\u908f\u8f2f\u3001\u63d0\u5347\u53ef\u8b80\u6027\uff0c\u4e26\u4e14\u53ef\u4ee5\u642d\u914d\u9069\u7576\u7684\u7d22\u5f15\u512a\u5316\u6548\u80fd\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1aRow Level Security (RLS) \u6253\u9020\u5b89\u5168\u7684\u8cc7\u6599\u5b58\u53d6 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[197],"tags":[309,310,301,311],"class_list":["post-296","post","type-post","status-publish","format-standard","hentry","category-supabase","tag-rls","tag-row-level-security","tag-supabase","tag-311"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=296"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/296\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}