DEFINITIONS

Definitions More Info.
Definition ID857
TitlePOSTGRESQL
CategoryNOTES
Definitionremove user from default priviliges
Definition Descriptionhttps://dba.stackexchange.com/questions/155332/find-objects-linked-to-a-postgresql-role

MAKALEYI MUTLAKA OKU

Önce kullnıcının tüm default yetkilerini postgres ver
-----------------------------------------------------
REASSIGN OWNED BY hbostanci TO postgres;

Sonra kullanıcı tarafından sahiplenilen yetkileri düşür
------------------------------------------------------
DROP OWNED BY hbostanci;

En sonda ise ROLE kaldır
------------------------
DROP ROLE hbostanci;
RecordBycunay
Record Date24-07-2018 12:01:52
Düzenle
Kopyala
Sil