If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Lost Admin priviledge.Please Help

Started by lifzgud, 13 Aug 2010 02:44:11 AM

Previous topic - Next topic

lifzgud

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:(

ducthcogtechie

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.