[SERVER-22733] Need SQL View like capability .. Created: 18/Feb/16 Updated: 07/Oct/16 Resolved: 18/Feb/16 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Concurrency, Querying, Security, Usability |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Daniel Farrell | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Participants: | |||||||||||||
| Description |
|
I'd like to request the addition of a SQL View like capability for security. To be as brief as possible- . You have a collection with 8 keys. Remove all permission from this OR, create the view with all columns, but a filter criteria is in place. . Now this user can read/write/whatever – . How others (SQL) does this- The view either enforces the underlying security of the source/ By default, security is inherited from the source collection. If you If the view is created { "with_admin_authority" : true }, then the view You might also want a { "with_check_option" }. In effect, if you . Phase 1, I'd be happy with projection and filter, and we'll call these Phase 2, "compound views", containing aggregated keys or simply . Query optimizer enhancement- If the view has a filter as part of its definition, and the user adds . Views on views- Added someday. Not needed on day one perhaps. |
| Comments |
| Comment by Daniel Pasette (Inactive) [ 07/Oct/16 ] |
|
This is supported in the current implementation coming in 3.4 and available in development versions. See |
| Comment by John Menke [ 07/Oct/16 ] |
|
Views on Views - is this something that is on the Roadmap? |
| Comment by Stennie Steneker (Inactive) [ 18/Feb/16 ] |
|
Hi Daniel, Thanks for your feedback. I'm going to close this as a duplicate of the existing feature suggestion for writable views (SERVER-10788). There is also a prerequisite feature suggestion for readable views ( Regards, |