To avoid “msg 15151 because it does not exist or you do not have permission.” call the following statement before create procedure and grant permission.

use <database name>
go

create procedure <procedure name>
as

select 
	[filed name] '1979', 
	[filedname] '1097', 
from [database name].[schema].[table name]
return 0
go

grant exec on [database name].[schema].[table name] to <login/user>
go