DEFINITIONS

Definitions More Info.
Definition ID823
TitlePOSTGRESQL
CategoryNOTES
Definitiontablo_table_uzerindeki_user_role_yetkileri_priviliges_GUZEL
Definition Descriptionhttps://dba.stackexchange.com/questions/4286/list-the-database-privileges-using-psql

SELECT privilege_type,table_schema,table_name
FROM information_schema.role_table_grants
WHERE
grantee = 'powerbi';

-------------------------------------------------------------------------------

SELECT
'GRANT ' || privilege_type || ' ON "' || table_schema || '"."' || TABLE_NAME || '" TO dwh;',
*
FROM
information_schema.role_table_grants
WHERE
table_schema = 'public'
AND privilege_type = 'DELETE'

------------------------------------------------------------------------------------------
SELECT
'GRANT ' || privilege_type || ' ON "' || table_schema || '"."' || table_name || '" TO planlama;',
*
FROM
information_schema.role_table_grants
WHERE
grantee = 'iyeter';
RecordBycunay
Record Date30-01-2018 10:02:26
Düzenle
Kopyala
Sil