Stored Procedures [dbo].[ADD_UND_USER]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@user_name_1nvarchar(75)150
@password_2nvarchar(75)150
@role_3nvarchar(75)150
@created_by_4bigint8
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecuteuniuser
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
Uses