Sharing Oracle views between users with preexisting table permissions
<p>Is it possible to grant permission to use a view when the grantee already has select permissions on the underlying tables but the grantor does not have "with grant" permissions on those tables? That is, can the grantee use the structure of the view but with their own underlying table permissions instead of the view owner's permissions?</p>

<p>For example, I have users A, B, and C. User A has some tables. Users B and C currently have identical select permissions on those tables. User B builds a view on those tables. Can user C use that view?</p>

<p>Note: I'm aware that if B is given "select with grant" permissions on those tables that this can run on B's permissions, but I don't want B to be able to grant their permissions forward; I only want users who already have permissions of their own to be able to use the structure of the view.</p>

<p>Context: I'd like to do some ad hoc work using some data in the A schema as queried through views already present in the B schema; this involves creating some tables to hold data sets I want to work with, but I don't want to clutter up the B schema with these tables while I'm working. Can I do this as user C by just copying user B's permissions on schema A without also having to recreate all of user B's views in the C schema? Is there an easier way to do this?</p>