Software update lets the Microsoft Service for DRDA activate application role permissions in SQL Server

Summary


This article describes a software update that lets the Microsoft Service for Distributed Relational Database Architecture (DRDA) activate permissions that are associated with an application role that's defined in a SQL Server database.

Software update information

A supported feature that changes the product's default behavior is now available from Microsoft Support. However, this feature is intended to change only the behavior that this article describes. Apply it only to systems that specifically require it.

This update is included in Cumulative Update 1 for Host Integration Server 2013.

After you apply the update, the Microsoft Service for DRDA is updated to support calling SQL Server system stored procedures, such as sp_setapprole. To call a SQL Server system stored procedure, such as sp_setapprole, you have to use a COBOL program on an IBM mainframe that uses static SQL to call the remote SQL Server system by using a CALL statement with parameters. The following example contains COBOL code that shows how to call the sp_setapprole stored procedure by passing two required parameters:

01 ROLENAM1                       PIC X(8).
01 PASSWD1                        PIC X(9).

MOVE 'approle1' TO ROLENAM1.                                 
MOVE 'Password1' TO PASSWD1.

EXEC SQL                                                    
     CALL NWIND.SYS.SP_SETAPPROLE                            
               (:ROLENAM1,:PASSWD1)                                
END-EXEC.

More Information

An application role in SQL Server is used to let an application run under a specific set of permissions. For more information about application roles, see the Application Roles topic in the SQL Server 2012 documentation. You enable application roles in SQL Server by calling the sp_setapprole stored procedure.

Frequently, access to data in a SQL Server databases is enabled based on application roles. By calling the sp_setapprole stored procedure through the Microsoft Service for DRDA, you let customers who use application roles manage access to SQL Server databases when they are being integrated with IBM DB2 databases.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×