example to give privs on packages instead of give privs directly on table to user to be better DB Security
| From: | Raúl Castro | 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?