2 Replies Latest reply on Apr 18, 2013 3:18 PM by Jason Lee

    Deactivate user's account in Pharos 8.2/8.3.

    Zhiyong Tian Adventurer
    Zhiyong Tian Apr 18, 2013 3:17 PM

      We only do "monitoring" for our faculty/staff in Pharos, and do not like to delete user's account after user left. I'm looking for a way to set Active to NO in Pharos automatically for these users. Looks like I can't use the Userload.exe to do this.

       

      Appreciate any of your infomation and suggestions.

        • Re: Deactivate user's account in Pharos 8.2/8.3.
          Jim Denk Wayfarer
          Jim Denk Apr 18, 2013 3:17 PM (in response to Zhiyong Tian)

          We do it by editing the database directly. The downside to this is that there is no transaction log for the status change.

           

          I have a script that runs daily and moves any users no longer in AD, or who have had their AD account disabled into a disabled users group, and I change their active status to NO.

          • Re: Deactivate user's account in Pharos 8.2/8.3.
            Jason Lee Adventurer
            Jason Lee Apr 18, 2013 3:18 PM (in response to Zhiyong Tian)

            We are v8.0, but hopefully this is still relavent for you.   We set the Active field on the User object to False with a direct SQL query out of Access.  We manage our users for various resources like AD, directories, Pharos, etc via Access and simply bind directly to the SQL instance to create and deactivate users with a simple query.

             

            dbo_users_v8 ~ bound external table in Access

             

            UPDATE dbo_users_v8 SET dbo_users_v8.active = 0
            WHERE (((dbo_users_v8.id)=[Forms]![users]![strSSO]));

             

            ... edit for disclaimer, code is action only, obviously you should do proper
            checking that the record exists and succeeds... as reference only.