[dbo].[sp_updateTenantOnDisHw]

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

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@newTentId	binary(16)	16
@asrcUuid	binary(16)	16

Permissions

Type	Action	Owning Principal
Grant	Execute	ca_itrm_group

SQL Script

create procedure sp_updateTenantOnDisHw(@newTentId binary(16), @asrcUuid binary(16))
as
begin
-- set correct tenant id

    update ca_discovered_hardware  set tenant_id = @newTentId
    where asset_source_uuid = @asrcUuid;
end;
GO
GRANT EXECUTE ON  [dbo].[sp_updateTenantOnDisHw] TO [ca_itrm_group]
GO

Uses

[dbo].[ca_discovered_hardware]
dbo