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! :'( :'(
Quote from: cjsasaki on 06 Sep 2019 05:04:20 PM
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.