KB112714 - INF: Grant or Revoke Permissions for ESQL Stored Procedures

MORE INFORMATION

Depending on your specific requirement, you may choose one of the following two options:

Using SQL scripts:

You can create an isql batch file that will select all stored procedures beginning with the program (or module) string, then use isql to grant permission on these procedures. For example, assume the ESQL/COBOL program name is myprog, then you can create a script file named
```
   getnames.sql:
      select "grant execute on ", name, " to public"
      from sysobjects
      where name like "myprog%"

						
```

Then run the following SQL scripts:

isql -Usa -Ppassword -Smyserver -igetnames.sql -ograntall.sql
isql -Usa -Ppassword -Smyserver -igrantall.sql

NOTE: You will need to modify the scripts GETNAMES.SQL and GRANTALL.SQL to remove the headers and other non Transact-SQL text, and add the necessary Transact-SQL commands such as "use yourdatabase" and "go". You can also use MS-DOS batch commands such as ECHO to automate the generation and execution of the scripts.

Using pre-compiled stored procedures:

Instead of having the ESQL/COBOL precompile service to generate the stored procedures for you, you can create the stored procedures yourself and simply call the stored procedures in place of the SQL statements. Using ESQL command EXECUTE, you can avoid a stored procedure from being compiled into another procedure when compiling the application.

INF: Grant or Revoke Permissions for ESQL Stored Procedures

SUMMARY

MORE INFORMATION