Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Software update lets the Microsoft Service for DRDA activate application role permissions in SQL Server

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

Third-party information disclaimer
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.

↑ Back to the top

Keywords: kbqfe, kbhotfixserver, kbfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2920658
Revision : 1
Created on : 1/7/2017
Published on : 4/1/2014
Exists online : False
Views : 343