Hi Edgar,

the 'active' column won't help you, that relates to the account activation
feature vie email.

Your other approach seems more viable. I would try deleting the smallest
subset of constrained entries - but unless you learn/understand the logic
behind the rows being deleted you are risking to end in an inconsistent
state. I would also limit this on the 'deleted' users only as a purged user
does not have to be deleted I think.

Martin

On Fri, Sep 9, 2016 at 7:41 AM Fernandez Edgar <edgar.fernan...@umontreal.ca>
wrote:

> Hello Martin,
>
>
>
> Thanks for the answer.
>
> I was hoping to find a way to remove the user or at the very least hide
> them from the ADMIN user page.
>
>
>
> After a small research in the database, I found a column called "ACTIVE"
> in the galaxy_user table.
>
> Can that column help me at all?
>
>
>
> OR
>
>
>
> I could write a script that search all the deleted/purged users, picks up
> their ID in the galaxy_user table and destroys all the lines in all the
> tables that has that FOREIGN KEY???
>
>
>
> Let me know what you think…
>
>
>
> *Edgar Fernandez*
>
> System Administrator (Linux)
>
> Direction Générale des Technologies de l'Information et de la Communication
>
> *Université de Montréal*
>
>
>
> PAVILLON ROGER-GAUDRY, bureau X-210
>
> (  Bur. : *1-514-343-6111 poste 16568*
>
>
>
>
>
> *From:* Martin Čech [mailto:mar...@bx.psu.edu]
> *Sent:* September-08-16 12:30 PM
> *To:* Fernandez Edgar <edgar.fernan...@umontreal.ca>;
> galaxy-...@bx.psu.edu
> *Subject:* Re: [galaxy-dev] delete user and all trace of user
>
>
>
> Hi Edgar,
>
>
>
> there is no built-in way in Galaxy to remove a user completely. 'Deleting'
> just flips the flag in the DB and 'purging' is related to their
> data/histories. You need to access the DB directly if you want to
> completely remove a user. Beware that there might be constraints/relations
> attached to the user row.
>
>
>
> Thanks for using Galaxy,
>
>
>
> Martin
>
>
>
> On Thu, Sep 8, 2016 at 12:22 PM Fernandez Edgar <
> edgar.fernan...@umontreal.ca> wrote:
>
> Hello gents!
>
>
>
> I’ve successfully got my version 16.04 up and running and everything is
> still there (user, groups roles, data and tools).
>
> Unfortunately , I’m still having a problem with deleting a user. I’ve
> purge him and then I deleted him.
>
> but, he still shows up in my list of users as "purged".
>
>
>
> Is there a way to completely remove him from galaxy?
>
> Do I need to run a script in a cron job to clean my galaxy periodically?
>
>
>
> Thanks in advance!
>
>
>
> *Edgar Fernandez*
>
> System Administrator (Linux)
>
> Direction Générale des Technologies de l'Information et de la Communication
>
> *Université de Montréal*
>
>
>
> PAVILLON ROGER-GAUDRY, bureau X-210
>
> (  Bur. : *1-514-343-6111 poste 16568*
>
> ___________________________________________________________
> Please keep all replies on the list by using "reply all"
> in your mail client.  To manage your subscriptions to this
> and other Galaxy lists, please use the interface at:
>   https://lists.galaxyproject.org/
>
> To search Galaxy mailing lists use the unified search at:
>   http://galaxyproject.org/search/mailinglists/
>
>
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

Reply via email to