[dbo].[ADD_UND

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@user_name_1	nvarchar(75)	150
@password_2	nvarchar(75)	150
@role_3	nvarchar(75)	150
@created_by_4	bigint	8

Type	Action	Owning Principal
Grant	Execute	uniadmin
Grant	Execute	uniuser

SQL Script

/****** Object:  Stored Procedure dbo.ADD_UND_USER    Script Date: 12/1/2005 11:49:11 PM ******/

/****** Object:  Stored Procedure ADD_UND_USER    Script Date: 3/25/2005 2:24:50 PM ******/
CREATE PROCEDURE [ADD_UND_USER]
    (@user_name_1     [nvarchar](75),
     @password_2     [nvarchar](75),
     @role_3     [nvarchar](75),
     @created_by_4     [bigint])

AS INSERT INTO [srdb].[und_user]
     ( [user_name],
     [password],
     [role],
     [created_by],
    [modified_by],
    [dt_created],
    [dt_last_modified])

VALUES
    ( @user_name_1,
     @password_2,
     @role_3,
     @created_by_4,
    @created_by_4,
    getdate(),
    getdate() )
GO
GRANT EXECUTE ON  [dbo].[ADD_UND_USER] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[ADD_UND_USER] TO [uniuser]
GO