[B! multitenancy] kiririmodeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kiririmode id:kiririmode

multitenancyã«é–¢ã™ã‚‹kiririmodeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

åå‰ç©ºé–“ã‚’ç”¨ã„ãŸQuickSightä¸Šã§ã®ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã®å®Ÿç¾ - stmn tech blog
Work illustrations by Storyset ã“ã‚“ã«ã¡ã¯ã€ã‚¹ã‚¿ãƒ¡ãƒ³ã®æ»¿æœ¬ã€è‹¥åœ’ã€ç”°ä¸ã€è¿‘è—¤ã§ã™ã€‚ã‚¹ã‚¯ãƒ©ãƒ ã§ã®ãƒãƒ¼ãƒ åã¯ã€ãƒãƒ¼ãƒ ããŽã¾ã§ã™ã€‚ (2022å¹´å†¬ã‹ã‚‰ã‚¹ã‚¯ãƒ©ãƒ é–‹ç™ºã«ç§»è¡Œã—ã¾ã—ãŸ) æœ¬è¨˜äº‹ã§ã¯ã€QuickSightã®æ¦‚è¦ã€ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆæ§‹æˆã¨ãã®é‹ç”¨æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ QuickSightã¨ã¯ QuickSightã¯ã€AWSãŒæä¾›ã—ã¦ã„ã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰BIã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ æœ¬é …ã§ã¯ã€QuickSightã®ä¸»ãªæ§‹æˆè¦ç´ ã§ã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã‚¢ã‚»ãƒƒãƒˆã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ QuickSightã§ã¯ã€ä¸‹è¨˜ã®3ç¨®é¡žã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ç¨®åˆ¥ãŒã‚ã‚Šã¾ã™ã€‚ ãƒãƒ¼ãƒ« æ¨©é™ç¯„å›² ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºç‰ˆã®è²»ç”¨ *1 ç®¡ç†è€…(ADMIN) å„ç¨®è¨å®šã®å¤‰æ›´, ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œæˆ 24ãƒ‰ãƒ«/æœˆ ä½œæˆè€…(AUTHOR) ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œæˆ 24ãƒ‰ãƒ«/æœˆ é–²è¦§è€…(READER) ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®é–²è¦§ æœ€å¤§5
kiririmode 2024/04/27
quicksight

multitenancy
ãƒªãƒ³ã‚¯
ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã«ãŠã‘ã‚‹Row Level Securityã®å…·ä½“çš„ãªå®Ÿè£…ã¨æ³¨æ„ç‚¹ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
æ–‡è„ˆã€èƒŒæ™¯ã‚„å•é¡Œç‚¹ã®èª¬æ˜Ž ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚’å®Ÿè£…ã™ã‚‹ã†ãˆã§ä¼æ¥æƒ…å ±ï¼ˆä»¥ä¸‹companyï¼‰å˜ä½ã§æœ€å°é™ã®æƒ…å ±ã‚’æ‰±ã†ã‚ˆã†ã«ã—ãŸã„ãŒcompanyå˜ä½ã«Tableã‚’ä½œã£ãŸã‚ŠDatabaseã‚’ä½œã‚‹ã®ã¯ALTERãªã©ã®é‹ç”¨ãŒå¤§å¤‰ã€‚ ãã“ã§RLSã‚’æŽ¡ç”¨ã™ã‚‹ãŸã‚ã«å®Ÿéš›ã®æŠ€è¡“æ¤œè¨¼ã‚’ã—ãŸä¸Šã§ã®æ³¨æ„ç‚¹ã¨å®Ÿéš›ã®é‹ç”¨ã«ã¤ã„ã¦å¿…è¦ãªæƒ…å ±ã‚’ã¾ã¨ã‚ã‚‹ã€‚ PostgreSQL 14ã‚’å‰æã¨ã—ã¦ã„ã‚‹ å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ CREATE POLICY å¿…ãšä¸€èªã¯ã™ã‚‹ã“ã¨ã€‚ å›°ã£ãŸã¨ãã€ã‚ã‹ã‚‰ãªã„ã¨ãã¯ã¾ãšã¯å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’éƒ½åº¦è¦‹ã‚‹ã“ã¨ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ã‚´ãƒ¼ãƒ« RLSã®æ¦‚è¦ã‚’ã¤ã‹ã‚ã‚‹ RLSã®æœ€ä½Žé™ã®æ³¨æ„ç‚¹ã‚’ç†è§£ã—ã€å®Ÿè£…æ™‚ã«ç½ ã‚’è¸ã¾ãªã„ è‡ªåˆ†ãŸã¡ã§RLSã®ãƒãƒªã‚·ãƒ¼è‡ªä½“ã‚’ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹ã“ã¨ãŒã§ãã€ãƒ‡ãƒãƒƒã‚°ã§ãã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆ create table if not exists company ( id uuid defaul
kiririmode 2024/03/14
ãƒ†ãƒŠãƒ³ãƒˆæ¯Žã«ã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆåˆ†ã‘ã‚‹å½¢ã§ã®RLSå®Ÿè£…

security

postgresql

rls

multitenancy
ãƒªãƒ³ã‚¯
Row Level Security ã§äº‹æ•…ã‚‰ãªã„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã™ã‚‹ - FLINTERS Engineer's Blog
ã“ã‚“ã«ã¡ã¯ã€æ¸…æ°´ï¼ˆ@_smzstï¼‰ã§ã™ã€‚ç›´è¿‘ã®æ¥å‹™ã§ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆãª DB ã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®ã‚¹ã‚¤ãƒƒãƒãƒãƒ¼ãƒ«æ©Ÿèƒ½ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã« Amazon Cognito ã‚„è¡¨é¡Œã«ã‚ã‚‹ Row Level Security ã«ã¤ã„ã¦æŠ€è¡“æ¤œè¨¼ã‚„è¨è¨ˆæ¤œè¨Žã‚’è¡Œã£ã¦ã„ã¾ã—ãŸã€‚ ä»Šå›žã¯ã“ã® Row Level Security ã«ã¤ã„ã¦ PostgreSQL ã§ã®ä¾‹ã‚’æŒ™ã’ã¦æŒ™å‹•ã‚’ç¢ºèªã—ãªãŒã‚‰ã€å®Ÿéš›ã«å°Žå…¥ã™ã‚‹ã«ã‚ãŸã£ã¦å¿…è¦ãªçŸ¥è˜ã‚„æ³¨æ„ç‚¹ã¾ã§ã‚’ç¶²ç¾…ã—ã¾ã™ã€‚æœ¬è¨˜äº‹ãŒå®‰å…¨ã§å …ç‰¢ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ã®ä¸€åŠ©ã¨ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ 1. ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã¨ã¯ 2. Row Level Security ã¨ã¯ 3. å®Ÿéš›ã«è©¦ã—ã¦ã¿ã‚‹ 3-1. å®Ÿç¾ã™ã‚‹ãŸã‚ã® SQL 3-2. RLS æœ‰åŠ¹åŒ–å‰ 3-3. RLS æœ‰åŠ¹åŒ–å¾Œ 4. è£œè¶³ 4-1. ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ 4-2. ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ãƒãƒ¼ãƒ«ã®ç®¡ç†ã«ã¤ã„ã¦ 4-3.
kiririmode 2022/09/10
ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚‚å«ã‚ãŸRLSã®é©ç”¨æˆ¦ç•¥

multitenancy

postgresql

rls
ãƒªãƒ³ã‚¯
PostgreSQLã®è¡Œãƒ¬ãƒ™ãƒ«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£(RLS)ãŒå®Ÿè¡Œè¨ˆç”»ã«ä¸Žãˆã‚‹å½±éŸ¿ã‚’ç¢ºèªã—ã¦ã¿ãŸ | DevelopersIO
ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆãªECã‚µã‚¤ãƒˆã®æ³¨æ–‡ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã¦ã„ã¾ã™ã€‚tenant_nameã®ã‚«ãƒ©ãƒ ã«ãƒ†ãƒŠãƒ³ãƒˆåãŒå…¥ã‚Šã€ã“ã®ã‚«ãƒ©ãƒ ã¨DBãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä¸€è‡´ã‚’è¡Œã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒãƒªã‚·ãƒ¼ã‚ˆã£ã¦ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç‰ã®æº–å‚™ ãã‚Œã§ã¯æ¤œè¨¼ç’°å¢ƒã‚’æº–å‚™ã—ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ä»Šå›žã®æ¤œè¨¼ã«ã¯PostgreSQLãƒãƒ¼ã‚¸ãƒ§ãƒ³11.11ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ã¾ãšã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆ CREATE TABLE orders ( id SERIAL PRIMARY KEY, tenant_name text, product_code text, order_date timestamp ); CREATE TABLE ç¶šã„ã¦ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆç”¨ã®DBãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œæˆ CREATE ROLE user01 LOGIN; CREATE ROLE CREATE SCHEMA "saas"; CREATE SCHEMA GRAN
kiririmode 2022/08/20
RLSã‚’ä½¿ã£ãŸæ™‚ã¯Policyã‚‚è¸ã¾ãˆãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆãŒå¿…è¦ã«ãªã‚‹

rls

postgresql

multitenancy
ãƒªãƒ³ã‚¯
Cognito ã‚’ä½¿ã£ãŸãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆæ§‹æˆã«ã¤ã„ã¦ãƒ¡ãƒ¢
Cognito ã‚’ä½¿ã£ãŸãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆæ§‹æˆã«ã¤ã„ã¦ã€æ–°ã—ã„å…¬å¼æƒ…å ±ãŒè¿½åŠ ã•ã‚Œã¦ã„ãŸã®ã§ç¢ºèªã—ãŸãƒ¡ãƒ¢ ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆæ§‹æˆã«ã¯ 4ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã®ã§ã€ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã«å¿œã˜ã¦æ¤œè¨Žã™ã‚‹æ„Ÿã˜ User Pool ãƒ™ãƒ¼ã‚¹ã«ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆ ãƒ†ãƒŠãƒ³ãƒˆæ¯Žã« User Pool ã‚’ä½œæˆã™ã‚‹ ãƒ†ãƒŠãƒ³ãƒˆæ¯Žã« MFA è¨å®šã‚„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒãƒªã‚·ãƒ¼ã‚’ç®¡ç†ã—ãŸã„å ´åˆã«é©ã—ã¦ã„ã‚‹ ãƒ†ãƒŠãƒ³ãƒˆã€ã¤ã¾ã‚Š User Pool æ¯Žã«ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã‚µã‚¤ãƒ³ã‚¢ãƒƒãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ ãƒã‚¤ãƒ¬ãƒ™ãƒ«ãªåˆ†é›¢ãŒå¯èƒ½ã ãŒé–‹ç™ºãƒ»é‹ç”¨ãŒãƒ„ãƒ©ã‚ ã‚¢ãƒ—ãƒªã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ™ãƒ¼ã‚¹ã«ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆ ãƒ†ãƒŠãƒ³ãƒˆæ¯Žã«ã‚¢ãƒ—ãƒªã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’ä½œæˆã™ã‚‹ User Pool è‡ªä½“ã¯ 1ã¤ ãªã®ã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç®¡ç†ã™ã‚‹ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚‚ 1ã¤ ã§è‰¯ã„ 1ã¤ ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ã—ã¦è¤‡æ•°ã®ã‚¢ãƒ—ãƒªã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒä½¿ç”¨ã§ãã‚‹ ãƒ›ã‚¹ãƒˆã•ã‚ŒãŸ UI ã‚’ä½¿ã†å ´åˆã€å„ã‚¢ãƒ—ãƒªã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ Cookie ãŒå…±æœ‰ã•ã‚Œ
kiririmode 2022/02/27
cognito

aws

multitenancy
ãƒªãƒ³ã‚¯
How to Navigate Multitenant Storage Strategies on AWS â€“ A New SaaS Whitepaper | Amazon Web Services
kiririmode 2021/02/13
DynamoDBã‚„RDSã«é–¢ã™ã‚‹ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®whitepaper

multitenancy

aws

dynamodb

rds
ãƒªãƒ³ã‚¯
ã¤ã‚‰ããªã„ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã‚’æ±‚ã‚ã¦: å…¨ã¦è¦‹ã›ã¾ã™ï¼ SmartHR ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è£å´ / builderscon 2018
ã¤ã‚‰ããªã„ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã‚’æ±‚ã‚ã¦: å…¨ã¦è¦‹ã›ã¾ã™ï¼ SmartHR ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è£å´ / buildersconÂ 2018
kiririmode 2021/01/27
multitenancy

db

mysql

postgresql
ãƒªãƒ³ã‚¯
1