Step 3: Grant Permission to Stored Procedures for User

This section explains how to grant permission to stored procedures for a user.

To grant permission to stored procedures for a user,

1. Select Programmability in ‘INW_IWMS’ database. Right-click <Procedure_Name>, and then select Properties in popup menu.

   

2. Select Permissions in Stored Procedure Properties – <Procedure_Name>, and then select Add.
3. Select Browse in Select Users or Roles window.
4. Select the user in Browse for Objects window, and then select OK. Select the user created testuser.

   

5. Selected user is displayed in the Select Users or Roles window. Select OK.
6. Grant the permission Execute for testuser. Select OK.