/****** Object:  Stored Procedure dbo.ujo_cred_get    Script Date: 12/1/2005 11:49:48 PM ******/
create procedure ujo_cred_get
     @cred_domain   varchar(8),
     @domain_name   varchar(64),
     @principal     varchar(64)

as

    if @cred_domain = 'ALL'
        select distinct cred_value, owner
        from ujo_cred
    else
    begin
        if exists (select cred_domain from ujo_cred where (
                         (cred_domain=@cred_domain) AND
                         (domain_name = @domain_name) AND
                         (principal=@principal)))

            select cred_value, owner from ujo_cred
                  WHERE    ( (cred_domain = @cred_domain)
                    AND   (domain_name = @domain_name)
                    AND  (principal= @principal) )

        else
            return 0
    end
    return 1
GO
GRANT EXECUTE ON  [dbo].[ujo_cred_get] TO [ujoadmin]
GO