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.
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
---------------------------------------------------------------------------------------------------
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.
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
---------------------------------------------------------------------------------------------------
hi,
what is that security metadata? r u saying the content store or any specific table for security? if so plese give full name.
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...
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
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.