|
-
One option might be to create a stored procedure under the user who owns the materialized views. In the procedure, you could refresh the views using dbms_mview.refresh(). The user then just calls this procedure.
If the procedure is created with definer rather than invoker rights (the default), then it should be executed under the privileges of the procedure owner rather than the user invoking it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|