/****** Object:  Stored Procedure dbo.ujo_cred_set    Script Date: 12/1/2005 11:49:48 PM ******/
create     proc ujo_cred_set
     @cred_domain   varchar(8),
     @domain_name   varchar(64),
     @principal     varchar(64),
     @cred_value    varchar(64),
     @owner         varchar(80)
AS

IF NOT EXISTS ( select cred_domain from ujo_cred where ((cred_domain=@cred_domain) AND (domain_name = @domain_name) AND (principal=@principal)))
BEGIN
     /* First time in - do an INSERT */
     INSERT ujo_cred ( cred_domain, domain_name, principal, cred_value,owner )
     VALUES     ( @cred_domain,@domain_name,@principal,@cred_value,@owner )

     return 1
END

/* Do an update */

UPDATE     ujo_cred
SET  cred_value = @cred_value,
     owner = @owner
     WHERE    ( (cred_domain = @cred_domain)
          AND   (domain_name = @domain_name)
          AND   (principal= @principal) )

return 1
GO
GRANT EXECUTE ON  [dbo].[ujo_cred_set] TO [ujoadmin]
GO