Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create role "Eve";
create table "tree_of_knowledge"(forbidden_fruit money default 666);
revoke all privileges on "tree_of_knowledge" from "Eve";
create view sinful_view with (security_invoker) as (
with original_sin as (
  select--no columns            --"I'm not touching anything"
  from "tree_of_knowledge"
  where false--nothing qualifies--"I'm really touching nothing"
  limit 0)--zero of those       --"Even if I was, I'm not"
  select 'Forgive me father for I have sinned.' repent --constant, unrelated to anything
  from original_sin --"I'm touching nothing, nowhere and there's nothing in there."
  limit 0           --"Not even, at all."
);
grant select on sinful_view to public;
set role "Eve";

CREATE ROLE

CREATE TABLE

REVOKE

CREATE VIEW

GRANT

SET

select repent from sinful_view limit 0;

ERROR:  permission denied for table tree_of_knowledge

select/*nothing*/ from sinful_view limit 0;

ERROR:  permission denied for table tree_of_knowledge