Stored Procedures [dbo].[JMO_WBR_Self]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@k_wbr_stidchar(21)21
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecuteemadmin
GrantExecutejmoadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_WBR_Self    Script Date: 12/1/2005 11:50:09 PM ******/


CREATE proc JMO_WBR_Self (
   @k_wbr_stid      char(21)
)
as
begin
   Select
      wbr_stid,
      wbr_groupid,
      wbr_node,
      wbr_type,
      wbr_timz,
      wbr_dsc
   From jmo_wbr
   Where
       wbr_stid         = @k_wbr_stid
   Order by
       wbr_stid
end
GO
GRANT EXECUTE ON  [dbo].[JMO_WBR_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_WBR_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_WBR_Self] TO [uniadmin]
GO
Uses