Print Page - Where are permissions stored in Content Store?

Title: Where are permissions stored in Content Store?
Post by: cccschip on 20 Dec 2012 07:11:31 AM

Yes ... I know that IBM doesn't publish this because it can change and they want you to use the SDK.

But I want to know where access permissions (Read, Write, Traverse, Execute, Policy) are stored in the Content Store database.

I would have expected something like CMREFORD1, but have found nothing.

Title: Re: Where are permissions stored in Content Store?
Post by: Grim on 20 Dec 2012 08:34:19 AM

This may help to find that out...

CM Browser Tool
http://www-01.ibm.com/support/docview.wss?uid=swg24021211

Using CMB
http://www.ibm.com/developerworks/data/library/techarticle/dm-0808masters/

Title: Re: Where are permissions stored in Content Store?
Post by: cccschip on 20 Dec 2012 09:20:37 AM

Thanks, but I'm still hoping someone can point me to the CM tables that actually contain the stored settings.

Title: Re: Where are permissions stored in Content Store?
Post by: mrcool on 03 Feb 2014 03:43:49 PM

Hi cccschip..Did you find the CM table?

Title: Re: Where are permissions stored in Content Store?
Post by: cccschip on 03 Feb 2014 04:31:21 PM

Sadly, no. :(

Title: Re: Where are permissions stored in Content Store?
Post by: mrcool on 05 Feb 2014 02:44:31 PM

Quote from: cccschip on 03 Feb 2014 04:31:21 PM
Sadly, no. :(

Title: Re: Where are permissions stored in Content Store?
Post by: Jack203 on 26 Feb 2015 09:05:59 PM

I am desperately trying to find the answer to this too.

I have gone through the cognos_cs tables with a fine tooth comb, and I cannot see anything which would logically relate folder to permissions.

If anyone knows how to do this in SQL it will be very appreciated.

Title: Re: Where are permissions stored in Content Store?
Post by: Andrew Weiss on 26 Feb 2015 09:46:45 PM

They are stored in the CMPOLICIES table as a long hexadecimal value. It's not readable.

MetaManager can provide an extract of security policies to an Excel file (or other) using the Content Documenter module.

See attached the attached file as an example output. Also you can see more information on the module here:
http://www.bspsoftware.com/Products/MetaManager/Document

Does this help with what you're trying to accomplish?

Thanks,
-Andy

Title: Re: Where are permissions stored in Content Store?
Post by: Jack203 on 26 Feb 2015 10:21:04 PM

Brilliant! Thank you Andrew Weiss.

Yes, it does help. MetaManager seems like a great tool.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: cccschip on 20 Dec 2012 07:11:31 AM