[dbo].[sp_lbf_invtblmap]

(local) > mdb > Stored Procedures > dbo.sp_lbf_invtblmap

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	ca_itrm_group

SQL Script

create procedure sp_lbf_invtblmap
as
begin

-- legacy bug fix
-- just in case table owner is wrong for the inv_default_xx tables
update inv_table_map set tbl_owner = 'dbo'
where table_name_item = 'inv_default_item';

end;
GO
GRANT EXECUTE ON [dbo].[sp_lbf_invtblmap] TO [ca_itrm_group]
GO

Uses

[dbo].[inv_table_map]
dbo