Delete a user with locked asset
I'm trying to delete a user but when I go to their 'locked asset's tab in the user administration area it says there is one locked asset with a strike through it (I believe this means it has been deleted). There is no clickable link for the asset so I can't navigate to the asset to break the lock.
When I login as the user and looked at the 'locked assets' widget or tab on the dashboard, there's nothing there.
How do I delete this user?
Thanks!
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
1 Posted by Ryan Griffith on 20 May, 2015 04:42 PM
Hi,
I think the easiest thing to do is going to be to manually remove the lock from the database.
Before we go ahead and remove the lock, I want to verify that the lock is ok to delete. When you have a moment, can you (or your DBA) try running this query against the database and attach the results:
Note: replace
USERNAME
with the username of the User you are unable to delete.Thanks!
2 Posted by e-jameson on 21 May, 2015 12:53 PM
Attached is the query results. Everything is null except for ID
3 Posted by Ryan Griffith on 21 May, 2015 03:53 PM
Thank you for providing the results of the query.
It looks like the user's lock does not reference anything in the
cxml_foldercontent
table. So, let's go ahead and try deleting the lock from the database by running the following query:Note: replace
USERNAME
with the username of the User you are unable to delete.After running the query, confirm the one row was affected and attempt to delete your user within Cascade and let me know if the delete is successful.
Please let me know if you have any questions.
Thanks!
4 Posted by e-jameson on 21 May, 2015 04:12 PM
Worked great thanks!
a-vennerstrom closed this discussion on 21 May, 2015 04:13 PM.