Can I turn off the SQL Insertable Object in Report Studio for all users?

[dougcl]

Hi folks, is it possible to turn off the SQL Insertable Object on the Queries Pane within Report Studio for all users?

If so, can it also be done from *some" users?

Thanks,
Doug

[christophers]

From Cognos Connection, go to Tools->Capabilities. From that you point you will see the list of the the different studios (i.e.: Report Studio, Query Studio, Cognos Viewer, etc.) Click on the link for Report Studio. You be in the Report Studio folder that contains the four items: Bursting, Create/Delete, User Defined SQL, and HTML Items in Report. Click the User Defined SQL- Set Properties Icon under Actions. When brought to that page click the permissions link at the top of the page. It will then display a list of Groups/roles with their action permissions. Click the "Override the access permissions acquired from the parent entry" check box and you should be able to set policy according the user or group.
Chris

[NaviGator]

nice post christophers ..

Thanks a lot ..

[dougcl]

This is great info. Thanks,
Doug