Udeshka

• Jul 30th, 2006

 

In Cognos 8, you can do it in three stages
1) Package Level
2) Object level
3) Data level

Package level
Expan the namespace,
R click on package > Click on Edit Package
Package Access window appears,
Remove "All users" from it
Click Adds,
select Cognos
Select "Report Administrator",
OK it,
save the package in Framework Manager (FM)
Publish the package
----------------------------------------------------

Object Level
Expan the namespace,
R click on a table > Click on "Specify Object Security"
On "specify Object Security" window,
click on ADD
On "select users and group" dialog box,
select Cognos
Select Report Administrator & Consumers
Click Add
In new window, under allow Report Administrator, deny consumer
Now R click on namespaces,
click on " Specift Object Security
"Here allow both consumers & Report Admni
Right click on packages,
"Explore package "
window opens
Select "Object security tab" appears
You will be allowed see who is allowed and who is not
-------------------------------------------------------

Data level
Right click on a table
Select query subject,
select "specify security filter"
"specify data security" dialog box appear
click on ADD
select cognos
select consumers,
Ok it
click the first row,
click on insert
In Filters folder,
select the appropriate filter
save the package and publish it