How To Obtain User Permissions from Oracle Server (156666)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 6.0
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 <datasource>, <user>, and <password> in the SQLStringConnect command with the appropriate values for your system.

Begin Code Example

   handle = SQLStringConnect("dsn=<datasource>;uid=<user>;pwd=<password>")
   status = SQLExec(handle, "Select * from SESSION_PRIVS", "SqlResult")
   IF (status < 1)
     ? "Unable to retrieve permissions"
   ELSE
     SCAN
       ? SqlResult.Privilege
     ENDSCAN
   ENDIF
Modification Type:MinorLast Reviewed:7/1/2004
Keywords:kbDatabase kbhowto kbinterop KB156666
©2004 Microsoft Corporation. All rights reserved.