Using Reporting Services rights
The following provides guidelines and restrictions when implementing Reporting Services rights.
Alerts
When an InfoSet is the input for an alert and also has Reporting Services rights, these rights will only be applied when the alert is accessed uisng the ShowDetails servlet and not delivered using email.
The rights will only be applied for a user when:
- The user is not the owner of the alert whose InfoSet(s) have rights
- The user must have a right, either through user name or role access, for the structure applied to the InfoSet.
Setting up Rights in Reporting Services
Consider the following when setting up rights in Reporting Services:
- Single and double quotes in an elements value are not allowed and will not work with the implementation of rights in Smart Notification.
- The wildcard character * will be applied in Smart Notification in the same manner it is in the Reporting Services rights environment, which means all values can be accessed.
Auditing
The following applies when audition is turned on. Working with auditing
The SQL that is generated for an InfoSet that has rights applied to it will be written to the FILTERDEFINITION column of the SNAUDIT table. The owner of the alert will not have any rights applied to the InfoSet and therefore will not have the SQL written to the SNAUDIT table.
If a user (who accesses an alert that they are not the owner of that’s based on an InfoSet that has rights applied to it) was not given either user or role access to the right the user will not see anything in the alert (besides the alert column names) from the applicable InfoSet. The SNAUDIT table FILTERDEFINITION column will have no SQL returned for user {userid} and InfoSet {infosetName} user may not have privileges for the right assigned to this InfoSet. written to it.
The rights will only be applied to the InfoSet rows whose ROWISNEW column is equal to 1. Any InfoSet condition that includes InfoSet rows where ROWISNEW is not equal to 1 will not be included in the result after applying the rights.