Hi all,
I was trying to set up Authentication on Cognos.
I integrated Sun One LDAP with Cognos and it worked.
However when i was setting permissions I must have missed out on something and as a result I have lost all the admin priviledges on all Users.I login with Administrator account(That i setup on LDAP )and it doesnt show Server Administration.I also enabled Anonymous Usage and that too has the same priviledges as other users.
please Help.Yes there a way i can reset everything back to where there is no authorisation set up for anyone?I dont have any previous backups as well:(
On your Cm database, run script c8\configuration\schemas\content\dbtype\AddSysAdminMember.sql and "everyone" will be back in the system administrator C8 group, getting you back in.