How to restore user group

[xcerv]

Hello,

one of our users deleted a user group. It is marked as deleted. The group is used for permissions on many objects in the system.
Is there a possibility to restore the group so we can use it again?

 

[appnair]

The table information of OT is protected but if you look around in many forums/examples you will see the relation
select * from usergrouptable where deleted=0 and type=0 the 0's mean it is active

a deleted group will be like this

select * from usergrouptable where deleted=1 and type=1

No warranties if you mess up your DB....

Very dangerous if you ask me.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[xcerv]

Thanks. I did know about the database option, I was wondering if there is some other supported way I might have overlooked.

However changing the Deleted to 0 did not revive the group, I can still see it as deleted. I’m sure this was working in the 9.7.1 version. We are on CS10 Update 12.

 

[xcerv]

My fault, its working.
Thanks.