I have a problem with the management of permissions.
I have UserA and UserB.
UserA owns a table T.
UserB can select the table T of UserA.
Now I want to allow UserA to create a view in
the schema of UserB.
How can I do it without using:
grant create any view to UserA
Thanks in advance
Why do you want user-A to create view in user-B ? Any specific reason ? If user-B can select table from user-A, user-B can create view right ? (Assuming User-B has privileges to create view). Am I missing something here ?
I want that UserB is allowed to update the view of UserA.
So, grant UserB - UPDATE priv on UserA's T. And if UserB has the create view priv, everything should be okay....
Why a view ?