use tempdb;
set ansi_nulls, quoted_identifier, xact_abort on;
go

create certificate cer1 encryption by password = '111111' with expiry_date = '30000101', subject = 'Test';
go

create user u1 for certificate cer1;
go

create table dbo.t1 (id int);
go

create procedure dbo.p1
as
begin
 exec('select * from dbo.t1');
end;
go

add signature to dbo.p1 by certificate cer1 with password = '111111';
go

create user u2 without login;
grant execute on dbo.p1 to u2;
go

execute as user = 'u2';
go
exec dbo.p1;
go
revert;
go

grant select on dbo.t1 to u1;
go

execute as user = 'u2';
go
exec dbo.p1;
go
revert;
go

drop procedure dbo.p1;
drop table dbo.t1;
drop user u2;
drop user u1;
drop certificate cer1;
go