We have a requirement to add a new view to an existing schema/owner. The schema currently has few objects tables/indexes, we want to give only select access to the new view, and not any access to existing objects tables/indexes.
Is there a way to restrict at login for that schema/owner, to only select from one view, and not from rest of the objects owned by the schema.