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

David Coallier's Blog: Simple DBAL, PHP5, Light, Fast, Simple.

Debuggable Blog: How to Group By in CakePHP's new release Part 2

Stuart Herbert's Blog: Microsoft's First PHP Extension: SQL Server 2005 Support

Sephiroth.it: Backup your batabases w/o phpmyadmin

Derick Rethans' Blog: Scalar Type Hinting and DB Design Slides


Community Events





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


list introduction voicesoftheelephpant security version tool release symfony podcast library interview series conference opinion language community laravel framework composer artisanfiles

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