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

 

Give server administration right to a user in content store database

Started by Raghuvir, 27 Jan 2015 05:38:50 AM

Previous topic - Next topic

Raghuvir

Hi all,


would it be possible to add a particular user to the server administrator role at the database level and not from the cognos administration screen.

please advice.

Regards

MFGF

Quote from: Raghuvir on 27 Jan 2015 05:38:50 AM
Hi all,


would it be possible to add a particular user to the server administrator role at the database level and not from the cognos administration screen.

please advice.

Regards

In theory you might be able to take the SQL that puts the "Everyone" group into the System Administrator role and hack it for a specific user (if you can figure out how to address that specific user in the content store).

The default SQL is in <install location>\configuration\schemas\content\<your content store db type>\AddSysAdminMember.sql

The propensity to get this wrong and corrupt your content store database is HUGE, though. It's a very risky and dangerous thing to do, and I would strongly recommend you steer well clear of it.

I'm not even going to ask why you'd want to do this in the first place... :)

MF.
Meep!

Raghuvir

Quote from: MFGF on 27 Jan 2015 06:42:31 AM
In theory you might be able to take the SQL that puts the "Everyone" group into the System Administrator role and hack it for a specific user (if you can figure out how to address that specific user in the content store).

The default SQL is in <install location>\configuration\schemas\content\<your content store db type>\AddSysAdminMember.sql

The propensity to get this wrong and corrupt your content store database is HUGE, though. It's a very risky and dangerous thing to do, and I would strongly recommend you steer well clear of it.

I'm not even going to ask why you'd want to do this in the first place... :)

MF.

Thanks for the guidance MFGF

Regards

Raghuvir

Quote from: MFGF on 27 Jan 2015 06:42:31 AM
In theory you might be able to take the SQL that puts the "Everyone" group into the System Administrator role and hack it for a specific user (if you can figure out how to address that specific user in the content store).

The default SQL is in <install location>\configuration\schemas\content\<your content store db type>\AddSysAdminMember.sql

The propensity to get this wrong and corrupt your content store database is HUGE, though. It's a very risky and dangerous thing to do, and I would strongly recommend you steer well clear of it.

I'm not even going to ask why you'd want to do this in the first place... :)

MF.

i ran the default script which executed successfully. i also turned the "allow anonymous access" to true in cognos configuration...restarted the services...but still m not able to get the administration access.

facing this issue as we have migrated from 8.4 to 10.2.1 and mapped the authentication to a new AD in which the previous users which were present in the administration role are not present. So thought if i could give a particular user administrator rights from the back end (SQL database tables)

Regards

MFGF

Did you stop the Cognos service before running the script and then start it afterwards, or did you run the script while the service was up?

Running the script while the service is stopped should give you Admin access - in fact it should give everyone Admin access, as it includes the Everyone group in the System Administrator role.

Cheers!

MF.
Meep!

Raghuvir

Quote from: MFGF on 27 Jan 2015 10:55:58 AM
Did you stop the Cognos service before running the script and then start it afterwards, or did you run the script while the service was up?

Running the script while the service is stopped should give you Admin access - in fact it should give everyone Admin access, as it includes the Everyone group in the System Administrator role.

Cheers!

MF.

Hi MFGF,

The problem was, script was not inserting the Everyone group to the system administrator role. so what i did is manually added everyone to system administrator group and took a back up of the content store database of cognos 8.4 and restored it to the new installed instance of 10.2.1 which solved my issue.

Thanks for the guidance

Regards