問題文
A dashboard must be usable by both the analytics team and the sales leadership. The sales role has access to the aggregate reporting views but not to the underlying transaction tables. What does this mean for the tile queries?
選択肢
- The tile queries must reference only the objects the viewing role can access, since the queries run with the viewer's own privileges.
- The sales role must be granted access to the transaction tables before it can view any dashboard built on them.
- The tile queries should be wrapped in a stored procedure so that the procedure's owner privileges apply to the viewer without any change to the tile.
- The tile queries can reference any object, because a dashboard runs with the privileges of the role that created it.