Results 1 to 6 of 6

Thread: Delete and user o Employee

  1. #1
    peraltaje is offline Junior Member
    Join Date
    Apr 2008
    Posts
    1

    Default Delete and user o Employee

    Hi., someone can help me to know how to delete and user or employee in Sugar 5.0
    regards, Juan ( peraltaje@planet.com.pa )

  2. #2
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: Delete and user o Employee

    In SugarCRM it is not part of the Master Plan to delete users or employees.
    You set their status to "Inactive" instead.

    You can only delete them if you drop their database rows in tavle users.
    But be absolutely sure that no other records have reference to these users - otherwise your application will be corrupted.

  3. #3
    vasanthsg is offline Junior Member
    Join Date
    Apr 2008
    Posts
    1

    Default Re: Delete and user o Employee

    You can set the "deleted" field to 1 for the user to be deleted in the "users" table of sugarcrm database. This will remove the user from the user listing in sugarcrm.
    Regards,
    Vasanth

  4. #4
    charkrue is offline Junior Member
    Join Date
    Apr 2008
    Posts
    2

    Wink Re: Delete and user o Employee

    If you are using MSSQL DB you can delete the users by not affecting the performance of your CRM program.
    you may use query and MSSL commands by verifying the table of your users db and then check whether the user exist in your users db. then you can do a query by deleting the user account.

    it works for me and the performance of my CRM 5.0 is not affected.

  5. #5
    pauliztarza is offline Junior Member
    Join Date
    May 2008
    Posts
    1

    Default Re: Delete and user o Employee

    Quote Originally Posted by kuske
    In SugarCRM it is not part of the Master Plan to delete users or employees.
    You set their status to "Inactive" instead.

    You can only delete them if you drop their database rows in tavle users.
    But be absolutely sure that no other records have reference to these users - otherwise your application will be corrupted.
    Well, how does one prevent users from deleting accounts ?

    I have inexperienced user and I am open to risk of having the accounts deleted.

  6. #6
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Delete and user o Employee

    Quote Originally Posted by pauliztarza
    Well, how does one prevent users from deleting accounts ?

    I have inexperienced user and I am open to risk of having the accounts deleted.
    Hi, pauliztarza

    If just the SugarCRM admin has access to database and this admin is a prudent person so you don´t have to worry about it.
    As Kuske told, you can mark the user as Inactive. This way that user can no longer access the system and the integrity between its id and all records related to that is saved.
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to delete a User or Employee?
    By paule123 in forum General Discussion
    Replies: 100
    Last Post: 2011-11-22, 02:45 PM
  2. Replies: 6
    Last Post: 2006-05-25, 05:32 AM
  3. Delete Employee or User problem
    By ctk in forum General Discussion
    Replies: 0
    Last Post: 2006-05-12, 06:10 PM
  4. Replies: 0
    Last Post: 2005-10-11, 03:18 AM
  5. Delete a User?
    By nzab in forum Help
    Replies: 1
    Last Post: 2004-12-09, 09:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •