Author Topic: LOST admin user/Privileges  (Read 2020 times)

Offline cjsasaki

  • Full Member
  • ***
  • Join Date: Dec 2015
  • Posts: 8
  • Forum Citizenship: +0/-0
LOST admin user/Privileges
« 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! :'( :'(

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,849
  • Forum Citizenship: +647/-10
  • Cognos Software Muppet
Re: LOST admin user/Privileges
« Reply #1 on: 09 Sep 2019 07:18:11 am »
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.
Meep!

 


       
Twittear