Step 3: Grant Permission to Stored Procedure for User Group

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

To grant permission for user group,

1. Select Programmability in INW_PRDB database. Right-click CheckProcessScheduleTime and select Properties in popup menu.

   

2. Select Permissions in Stored Procedure Properties – CheckProcessScheduleTime, and then select Add.
3. Select Browse in Select Users or Roles window.
4. Select the user group in Browse for Objects window, and then select OK. Select the user group created InnoUserGrp.

   

5. Selected user group is displayed in Select Users or Roles window. Select OK.
6. Grant the permission Execute for ‘InnoUserGrp’.