DEFINITIONS
Definitions More Info.
Definition ID
12.070
Title
POSTGRESQL
Category
NOTES
Definition
DB uzerindeki tum tablolara yetki -SELECT,INSERT,UPDATE,DELETE
Definition Description
SELECT
'GRANT ' || privilege_type || ' ON "' || table_schema || '"."' || TABLE_NAME || '" TO consentapp;',
*
FROM
information_schema.role_table_grants
WHERE
table_schema = 'public'
AND (privilege_type = 'DELETE'
OR privilege_type = 'INSERT'
OR privilege_type = 'UPDATE'
OR privilege_type = 'SELECT')
RecordBy
cunay
Record Date
17-05-2022 11:16:16
Düzenle
Kopyala
Sil