feat: support MAINTAIN privilege in PG17

soedirgo · soedirgo · commit 2e30e9fe31d9 · 2024-12-04T22:34:48.000+08:00
diff --git a/src/lib/sql/table_privileges.sql b/src/lib/sql/table_privileges.sql
@@ -64,7 +64,7 @@ where c.relkind in ('r', 'v', 'm', 'f', 'p')
     pg_has_role(c.relowner, 'USAGE')
     or has_table_privilege(
       c.oid,
-      'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'
+      'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, MAINTAIN'
     )
     or has_any_column_privilege(c.oid, 'SELECT, INSERT, UPDATE, REFERENCES')
   )
diff --git a/src/lib/types.ts b/src/lib/types.ts
@@ -506,6 +506,7 @@ export const postgresTablePrivilegesSchema = Type.Object({
         Type.Literal('TRUNCATE'),
         Type.Literal('REFERENCES'),
         Type.Literal('TRIGGER'),
+        Type.Literal('MAINTAIN'),
       ]),
       is_grantable: Type.Boolean(),
     })
@@ -525,6 +526,7 @@ export const postgresTablePrivilegesGrantSchema = Type.Object({
     Type.Literal('TRUNCATE'),
     Type.Literal('REFERENCES'),
     Type.Literal('TRIGGER'),
+    Type.Literal('MAINTAIN'),
   ]),
   is_grantable: Type.Optional(Type.Boolean()),
 })
@@ -542,6 +544,7 @@ export const postgresTablePrivilegesRevokeSchema = Type.Object({
     Type.Literal('TRUNCATE'),
     Type.Literal('REFERENCES'),
     Type.Literal('TRIGGER'),
+    Type.Literal('MAINTAIN'),
   ]),
 })
 export type PostgresTablePrivilegesRevoke = Static<typeof postgresTablePrivilegesRevokeSchema>

Original file line number	Diff line number	Diff line change
`@@ -64,7 +64,7 @@ where c.relkind in ('r', 'v', 'm', 'f', 'p')`
`64`	`64`	`pg_has_role(c.relowner, 'USAGE')`
`65`	`65`	`or has_table_privilege(`
`66`	`66`	`c.oid,`
`67`		`- 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'`
	`67`	`+ 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, MAINTAIN'`
`68`	`68`	`)`
`69`	`69`	`or has_any_column_privilege(c.oid, 'SELECT, INSERT, UPDATE, REFERENCES')`
`70`	`70`	`)`