Views can be created using the SECURITY INVOKER parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.
SECURITY INVOKER