I'd like to give permissions to a manager to see all rows that have a value of either NY or NJ in the state field, regardless of who owns or created the rows.
First, I'm new to dataverse permissions, so please tell me if this simply isn't a core use case. In an ASP.Net / SQL app, the user account would have no access to the tables, and they'd only have access to the data via the web page, which would only show them data based on this criteria. In dataverse, the user account needs read access to the table. Can I give them access to a view but not the table?
Or, is it more like sql than I realize? Do I give the user access to the table and create the canvas app that only shows them the filtered view? If they're just a user, do they not have any other means of accessing the table data other than the provided app?
