[dbo].[JMO_MWC_Del]
(local)
>
mdb
>
Stored Procedures
> dbo.JMO_MWC_Del
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@k_mwc_clus
char(21)
21
@k_mwc_name
char(17)
17
Permissions
Type
Action
Owning Principal
Grant
Execute
emadmin
Grant
Execute
jmoadmin
Grant
Execute
uniadmin
SQL Script
/****** Object: Stored Procedure dbo.JMO_MWC_Del Script Date: 12/1/2005 11:49:21 PM ******/
CREATE
proc
JMO_MWC_Del
(
@k_mwc_clus
char
(
21
),
@k_mwc_name
char
(
17
)
)
as
begin
Delete
From
jmo_mwc
Where
mwc_clus
=
@k_mwc_clus
and
mwc_name
=
@k_mwc_name
end
GO
GRANT
EXECUTE
ON
[dbo]
.
[JMO_MWC_Del]
TO
[emadmin]
GRANT
EXECUTE
ON
[dbo]
.
[JMO_MWC_Del]
TO
[jmoadmin]
GRANT
EXECUTE
ON
[dbo]
.
[JMO_MWC_Del]
TO
[uniadmin]
GO
Uses
[dbo].[jmo_mwc]
dbo