News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Oracle Technology Network:
PHP Web Auditing, Authorization and Monitoring with Oracle Database
September 13, 2010 @ 14:10:25

On the Oracle Technology Network today there's a new article from Chris Jones about using the client identifier in the OCI8 PHP-to-Oracle connections to help with auditing, profiling and monitoring your Oracle database usage.

This "client identifier" can be used by Oracle Database to distinguish between individual web application users who all connect to the database using one common set of database credentials. For example, every page in a web site might physically connect to the database as the same database user PHPUSER. If two different people 'Chris' and 'Alison' are using the site, these two user names can be set as their respective client identifiers and be passed into the database.

He shows how to set these client identifiers via the oci_set_client_identifier function (and how you could use it in older versions of the OCI8 driver too). He provides a sample application to help you get a good overall picture complete with SQL to load the database and a basic login page to submit and pull that data back out.

He moves over to the database side where he talks about enabling auditing, pulling out the logged application ID and how to use this identifier to restrict access via a Virtual Private Database on the Oracle side.

0 comments voice your opinion now!
authorization monitoring auditing oracle database oci8


blog comments powered by Disqus

Similar Posts

Builder.com.au: Creating and managing a Mysql database with phpMyAdmin

Christopher Jones' Blog: PHP OCI8 1.3.3 has gone "Production"

Lorna Mitchell's Blog: Script for Database Patching at Deploy Time

Christopher Jones' Blog: Oracle Instant Client 10.2.0.4 for Mac OS X Intel x86 is Available

Christopher Jones\' Blog: Updated Oracle PHP Installation Guides


Community Events

Don't see your event here?
Let us know!


example composer yii2 laravel part2 symfony language community api opinion series project interview framework application introduction php7 podcast programming list

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework