Hi all, On login role properties window, "Definition" tab, there is account expire date. Odd thing is that checkbox is checked and date is assigned even when there is no valid date set on account. Consequence is when you click "OK" button without do anything, then SQL:
ALTER ROLE "MyRole" VALID UNTIL '1970-01-01 00:00:00'; is executed, so user would not be able to login again, because account expired. SQL is prepared at very beginning, Simply open "Properties" on login node and click "SQL" tab - script is ready to be executed. Works this way for roles without validity term. Regards, Bartek
