Posts: 56
Threads: 17
Joined: Apr 2012
Reputation:
0
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...
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
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'
Regards/Gruss
Oliver
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
That's the right place - the user will be asked when trying to login to set a new password...
Regards/Gruss
Oliver
Posts: 56
Threads: 17
Joined: Apr 2012
Reputation:
0
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 ...
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
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?
Regards/Gruss
Oliver
Posts: 56
Threads: 17
Joined: Apr 2012
Reputation:
0
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..."
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
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...
Regards/Gruss
Oliver
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
You can also try to run the DataOptimizer - perhaps any corrupt data will be found that you can delete
Regards/Gruss
Oliver
Posts: 11,045
Threads: 99
Joined: Aug 2006
Reputation:
198
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...
Regards/Gruss
Oliver
Posts: 56
Threads: 17
Joined: Apr 2012
Reputation:
0
after data optimalisation it works
thx Oliver