This content has been marked as final. Show 3 replies
If the user has been granted select on the view the user does not need to have any privileges on the underlying table(s).1 person found this helpful
That's kinda the idea. Views can be used to hide certain information from the user.
you should grant the user that privilege :
grant select on view to <USERNAME>;
Thank you for the reply :)