LOST admin user/Privileges

[cjsasaki]

Hi
I have cognos 11.1R1 and easy setup.
By accident I have lost my privileges as an admin. I found in the forum that I can run the script AddSysAdminMember.sql (https://www.cognoise.com/community/index.php/topic,9759.0.html)

But how do I run that script?
Please help me! :'( :'(

[MFGF]

Hi
I have cognos 11.1R1 and easy setup.
By accident I have lost my privileges as an admin. I found in the forum that I can run the script AddSysAdminMember.sql (https://www.cognoise.com/community/index.php/topic,9759.0.html)

But how do I run that script?
Please help me! :'( :'(

Hi,

The Easy Setup installs an Informix instance to host the Content Store database. You will need an Informix SQL client to allow you to run the SQL script to re-instate your System Administrator privileges to the Everyone group - something like SQL Squirrel should work, I imagine. I haven't tried it, though.

Good luck!

MF.