How To Obtain User Permissions from 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