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_PRDB’ 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 will be displayed in Select Users or Roles window. Select OK.
6. Grant the permission Execute for ‘testuser’.