DEFINITIONS

Definitions More Info.
Definition ID12.070
TitlePOSTGRESQL
CategoryNOTES
DefinitionDB uzerindeki tum tablolara yetki -SELECT,INSERT,UPDATE,DELETE
Definition DescriptionSELECT
'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')
RecordBycunay
Record Date17-05-2022 11:16:16
Düzenle
Kopyala
Sil