Re: Who dropped a role?

Hello

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Durumdara
Sent: Donnerstag, 8. Dezember 2016 10:13
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Who dropped a role?

Hello!

Sorry, meanwhile I found it as Group Role.

I never used this kind of role. How to restore it to normal login role?

ALTER ROLE ... LOGIN;

You probably need to reassign the password (I don’t remember right now if the pw is dropped when changing form LOGIN to NOLOGIN).

\password ...

Thanks for it!

dd

2016-12-08 9:53 GMT+01:00 Durumdara <durumdara(at)gmail(dot)com <mailto:durumdara(at)gmail(dot)com> >:

Dear PG Masters!

In a server today I didn't find an important role.

I don't know what my colleagues did with it, but it seems to be lost.

Do you know a trick, how get info about it?

1.) Who dropped it?

2.) If not dropped what happened with it?

Does role dropping logged somewhere?

Thanks for your help!

dd