[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: how to manually remove a user from DB?



hmmmm  can you try:
alter user username WITH VALID UNTIL 'tomorrow';

See if that fixes the problem

On Fri, Nov 21, 2014 at 1:24 AM, Max van Biezen <..hidden..> wrote:
the user cannot log on after I removed the entries from the tables.
In the tab user of employee there is now a username field which is
empty and an empty pssword field. Setting a value in both does not
give an error but a the user cannot log on. After checking DB, there
is no new entry added to user nor user_preference. It is not that
important. I will make a new user. There was no user activity yet. The
only thing to correct is that one should not be able to create an
account by accident in this way by using setup.pl, though a bug was
filed for that already IIRC.

On 21 November 2014 08:15, Max van Biezen <..hidden..> wrote:
> On 20 November 2014 23:24, Chris Travers <..hidden..> wrote:
>> In 1,4, you are resetting the password through the employee screen?
>
> Yes. HR/search/employee

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users