example to give privs on packages instead of give privs directly on table to user to be better DB Security

From: Date: Wed, 14 Jul 2004 16:59:05 +0000
Subject: example to give privs on packages instead of give privs directly on table to user to be better DB Security
Groups: php.general 
Request: Send a blank email to php-general+get-190507@lists.php.net to get a copy of this message
In Oracle, a stored procedure executes under the owners identity, not under the identity of the caller. Therefore I have knowed that many applications use packages to execute insert, update, select, delete statements instead of give user privileges directly on table. I'm creating a web application using php and Oracle, but I want to use this programing method, I would like to have some example to help me to understand, do you have one? This method is suitable on web applications?

« previous php.general (#190507) next »