Single Admin Id Deleted :: How 2 Grant Access to Everyone ?

[spalkar]

 We had secured the cognos and had set up webadmin ( as a single administrator)
  The webadmin id got deleted, and any and all users now only have a COMSUMER only access..

  Can you someone tell me, which table in the SQL Server, I can update to let in a new admin ?
  Or is there a way that the whole security can be reInitialized ?

  Thanks,
Saurabh
Configuration ::
Cognos v8 Windows, using Series 7 Access Manager and SQL Server as the database....

[praveennb]

Option 1.
stop cognos service
Restore content manager from backup.


option 2
stop the cognos services
Please backup your content store and run the script located in
c:\Program Files\cognos\c8\configuration\schemas\content\sqlserver\
AddSysAdminMember.sql, you will need to run this inside the Content Database.

Running this script will add the Everyone Group to the System Administration group, it would be better next time to create 2 administrator accounts once to be used for daily needs another in case of emergency .

once you have added the new users to the admin group, you could disable the everyone group


Hope this works for you.