How to get the user login permissions information through content store database

[Subb Rayudu]

Hi,

I need the information about what are the users are access the particular reports and their permissions of the cognos connection. I am using the Sql Server. where can i get the user login permissions information. i need Group wise and user wise by role.

I am new in the [Cognos]. I am using Sqlserver for database. users information stored in the Security metadata in sql server database. i am very poor in the sql server queries.... please help on this.

[Prerna Chaudhary]

Hi,

I am not sure about how can you view it in SQL server.But if you want to access it through Cognos Administration,You can follow the steps mentioned below:

1.Launch Cognos Administration from Cognos Connection
2.Click on the Security Tab
3.Click on "Capabilities"
4.You will be able to see the names of various Studios there
5.Click on the "Set properties option" which appears  when you place your mouse control over an inverted triangular icon named" Actions"
6.Click on the "Permissions" tab
7.You will be able to see the Access Permissions provided to different groups and roles

Please find above the attached snapshot for the same.

Hope this fixes your issue.

Thanks and regards
Prerna
---------------------------------------------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
---------------------------------------------------------------------------------------------------

[Subb Rayudu]

Thanks Chaudhary.

But i want all users information. througgh your steps i got the self login or permission details only.

I need the entire users and theire groups permission.

I think Content store database only we get the users and there permissions.

please help me.

[Prerna Chaudhary]

Hi,

Please refer Security metadata in your database in the SQL Server. All the information regarding users and their group permissions is stored there.

Do let me know if any further help is required.

Thanks and regards
Prerna
---------------------------------------------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
---------------------------------------------------------------------------------------------------

[Cognos8]

hi,

what is that security metadata? r u saying the content store or any specific table for security? if so  plese give full name.

[Subb Rayudu]

Through Sql Queries, How to get the how many users are able to used the cognos connection and what types of permissions he/she has...

[RobsWalker68]

Hi,

Have a look at using the Cognos Audit extension of this.

http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page509.html

Kind Regards


Rob

[PolzovatelCognos]

Perhaps the following link might help, the following describes the Cognos Content store tables and what each table captures:
http://www.cogknowhow.com/index.php/library/48-cognos-content-store-database-tables-description-

I.e.,
Table name   Descrition

CMSYSPROPS   This table has the Content Store Version.   
CMOBJNAMES   This table has the names of all the objects in the content store.   
CMOBJPROPS1   Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table   
CMOBJPROPS2   Report scheduling information is stored. This table has fields like hour, day week etc   

etc...

I was able to get the information from the Cognos Audit extension, however, which comes with sample reports to help you begin.