My goal is that i want to provide users access to a view but not the underlying tables. I only want them to see specific columns and rows of the table. When i just give the select permissions on the view the user gets an error that they also need access to the underlying tables. When i give select permissions on the underlying table they are able to select data from the view.

Is there a way to give the users only access to the view and not the underlying tables or am i doing something wrong here.

Any help is much appreciated!