In the Edit User page, the delete user function not working. I have full admin permissions. Something with the javascript: delt not defined. Any help is always appreciated.

asked 13 Aug '15, 16:08

gwildgoose's gravatar image

gwildgoose
1071722
accept rate: 0%

edited 13 Aug '15, 16:12


I have never looked at that part of the code. But a workaround could be to deny all permissions to that user. Klaus
permanent link

answered 14 Aug '15, 08:57

opto's gravatar image

opto ♦
8234082129
accept rate: 10%

answered 14 Aug '15, 08:57

You can't just delete a user or any other item, since this is a relational database and it will create data corruption (for example, there will be tasks that this user was assigned, the database will still hold the user ID in its reference, but the ID will point to NULL!!!). You just disable the user, by denying all permissions and changing the password to something extremely long and absurd, just to be sure...\nThat is what I do in the University's Campus Telephone Directory database. NO DELETIONS, ONLY DISABLING...
permanent link

answered 18 Aug '15, 04:05

Themoulos's gravatar image

Themoulos ♦
21791421
accept rate: 22%

answered 18 Aug '15, 04:05

Hello Themoulos, I tend to disagree with your assessment, I have never had problems deleting users in the past, also I have no problem deleting tasks, projects, events or anything else out of the database.\nBesides why would the developers put the option in the edit user page as shown in the attachment? It's because it is relational that you can delete the user, the record is relational to every other table where the instance resides.![alt text][1] [1]: /storage/temp/282-delete-user.png
permanent link

answered 18 Aug '15, 17:44

gwildgoose's gravatar image

gwildgoose
1071722
accept rate: 0%

edited 18 Aug '15, 17:48

This is not right in a relational database. Suppose you have a project whose Project Owner is UserA and the project has ten tasks, assigned to projectWorker1,projectWorker2 and projectWorker3. The project finishes OK and then you decide that you no longer need UserA and projectWorker2, who have left the company. If you delete them and visit the finished project again, can you tell me who the Project Owner was? A reference to a deleted record? Who completed the tasks that projectWorker2 did? User NULL??? If it happens, data integrity has been broken. You can't have a project whose Project Owner is NULL... The ONLY condition you can delete a record is when it is not referenced anywhere else in the database. That is you can delete a whole company with its projects, users, etc. THAT is OK. You can also delete a project that is standalone, with its tasks, users, etc. You can delete a task that is no other task's parent. You can remove a specific user's reference in tasks, projects etc and then delete him. But you can just go to Users List, and delete him. Even if the database allows you to perform it, it is bad practice. Think about it not in a matter of ONE project, but over years and you will agree with me. In a relational database, the most valuable thing you should pay attention to is data integrity. My advice: DO NOT EVER BREAK IT.
permanent link

answered 20 Aug '15, 07:28

Themoulos's gravatar image

Themoulos ♦
21791421
accept rate: 22%

answered 20 Aug '15, 07:28

It has been a while since I did this, but as I recall, \"Delete\" just removes the roles and places the user in an \"Inactive\" status. If you go to the inactive users page, you'll still see them.
permanent link

answered 20 Aug '15, 15:44

mckinnej's gravatar image

mckinnej
102411
accept rate: 0%

answered 20 Aug '15, 15:44

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×7
×1

question asked: 13 Aug '15, 16:08

question was seen: 831 times

last updated: 20 Aug '15, 15:44

powered by Bitnami OSQA