Access Deniied to view created by other owner

[njalan]

How to access to view created by other owners on the schema which query user has the access.

[leeyh0216]

Hello,

When creating a view, you can set the definer and invoker with the SECURITY option.

Probably, if a view is created based on the definer, and the definer has permission for the view, it will run normally without permission issues even if someone else runs it.