Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test(id int,description text,priv text);
insert into test select 1,'description','priv';

select * from test;

CREATE TABLE

INSERT 0 1

id
description
priv

1
description
priv

SELECT 1

create view v_test as select id,description from test; 
alter table test drop column description,
                 alter column id type bigint,
                 add column description uuid default gen_random_uuid();

CREATE VIEW

ERROR:  cannot drop column description of table test because other objects depend on it
DETAIL:  view v_test depends on column description of table test
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

create function f_test() 
  returns table(id int, description text) 
  security definer language sql as '
  select id,description from test';
drop view if exists v_test;
create view v_test as select * from f_test();
select * from v_test;

alter table test drop column description,
                 alter column id type bigint,
                 add column description uuid default gen_random_uuid();

select * from v_test;

CREATE FUNCTION

DROP VIEW

CREATE VIEW

id
description

1
description

SELECT 1

ALTER TABLE

id
description

1
5237bbf5-f7e4-4de6-a8b9-3b91437312a5

SELECT 1

create role restricted_role;
grant select on v_test to restricted_role;

CREATE ROLE

GRANT

set role restricted_role;
select current_user;
select * from v_test;
select * from f_test();
select * from test;

SET

current_user

restricted_role

SELECT 1

id
description

1
5237bbf5-f7e4-4de6-a8b9-3b91437312a5

SELECT 1

id
description

1
5237bbf5-f7e4-4de6-a8b9-3b91437312a5

SELECT 1

ERROR:  permission denied for table test