Microsoft KB Archive/156666

= How To Obtain User Permissions from Oracle Server =

Article ID: 156666

Article Last Modified on 7/1/2004

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q156666



SUMMARY
This article describes one method of determining what privileges a user has on an Oracle server.



MORE INFORMATION
The following code example demonstrates how to obtain user permissions from an Oracle server. Before attempting to run this code, be sure to replace the, , and in the SQLStringConnect command with the appropriate values for your system.

Begin Code Example
handle = SQLStringConnect("dsn= ;uid= ;pwd= ") status = SQLExec(handle, "Select * from SESSION_PRIVS", "SqlResult") IF (status < 1) ? "Unable to retrieve permissions" ELSE SCAN ? SqlResult.Privilege ENDSCAN ENDIF

Keywords: kbhowto kbinterop kbdatabase KB156666

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.