Lost Admin rights

[support@heens-it.be]

Hi, somehow I've lost the admin rights to give other users permissions on folders, (public) credentials and connections
I also can't see the security groups anymore.
Is there a way to reenable those security rights?
I do have full access to the SQL server and tables...

[DevOma]

You can deactivate Permissions by SQL and if you enable it again you will be added automatically to the Administrators group.

DELETE FROM ItemProperties WHERE ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF' and RolePropertyId = '2924F6D4-8AB0-4EA4-8FE7-1BB078EC86B7'

[support@heens-it.be]

You can deactivate Permissions by SQL and if you enable it again you will be added automatically to the Administrators group.

DELETE FROM ItemProperties WHERE ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF' and RolePropertyId = '2924F6D4-8AB0-4EA4-8FE7-1BB078EC86B7'

Thanks Olivier.
It worked...

Now I want to create an extra internal user who I want to give access.
I already create a new Security Group and gave access to the Object, it's allowed to access.
But the only place I see where I can create a user is Tools - Security groups... but then I can't give that user a password...?
What am I doing wrong and how can I add a new user or give it a password and access?
(or later on reset the password if needed) 

[DevOma]

That's the right place - the user will be asked when trying to login to set a new password...

[support@heens-it.be]

ok tnx that worked.
When I first start as the user, it indeed does asks for a password.
But then it just "hangs" at Loading data...?
no notifications, no objects ...

[DevOma]

Really? I tried myself and it worked - did you type a password and confirmed it afterwards? Can you try to add a internal user to Administrators? Is that working? Which permissions have you assigned to your group?

[support@heens-it.be]

Sorry, no got the mail that you updated the thread/ticket ;-)
We did indeed we're able to give and activate the password.
It just "hangs" at "loading data..."

[DevOma]

Ok - did you add the user to a custom security group? Or assigned to Administrators? There must be any difference I would like to find to my testings...

[support@heens-it.be]

Ok - did you add the user to a custom security group? Or assigned to Administrators? There must be any difference I would like to find to my testings...

It's a custom security group. should only have access to some folders (and subfolders)

[DevOma]

You can also try to run the DataOptimizer - perhaps any corrupt data will be found that you can delete

[DevOma]

Also you can try to move the user to another Security Group - only to check the difference - I have done a lot of different things but can't reproduce

If nothing helps you send me a backup of the database to asg.rd@asg.com and I will try to find the issue...

[support@heens-it.be]

after data optimalisation it works
thx Oliver