I want users to be able to create a query view but in a way that only the user that created it has access to the view. In fact this would be something like a local view of the query.
Is there a way to do this automatically or would I have to maintain authorizations manually always which is not very efficient? How can it be done if it can at all?
Thank you for your help.