|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2006-07-21 18:32 UTC] jkeller at berkeley dot edu
Description: ------------ We would love to be able to use Oracle database "proxy authentication" with the oci8 library. Proxy authentication is supported by Oracle's OCI library. It would allow us to use an external authentication source (LDAP) and then securely pass the user identity to the database (so it is available for things like auditing and "fine-grained access control" at the database level). If it is not difficult to add support for this feature to the PHP oci8 library, we would really appreciate it. PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 20 21:00:02 2025 UTC |
Partial functionality exists. Pre-Test requirements: create user app identified by "ppa"; create user bob identified by "obo"; grant create session to app; grant create sesion to bob; alter user bob connect through app; PHP Test <?php require dirname(__FILE__)."/connect.inc"; $pc = oci_connect("app[bob]", "ppa", $dbase); $stmt = oci_parse($pc, "select user from dual"); oci_execute($stmt); var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS)); $t = oci_close_proxy_session($pc); echo "Done\n"; ?> result: array(2) { [0]=> string(3) "BOB" ["USER"]=> string(3) "BOB" }EDIT to remove oci_close_proxy_session line. -- Partial functionality exists. Pre-Test requirements: create user app identified by "ppa"; create user bob identified by "obo"; grant create session to app; grant create sesion to bob; alter user bob connect through app; PHP Test <?php require dirname(__FILE__)."/connect.inc"; $pc = oci_connect("app[bob]", "ppa", $dbase); $stmt = oci_parse($pc, "select user from dual"); oci_execute($stmt); var_dump(oci_fetch_array($stmt, OCI_RETURN_NULLS)); echo "Done\n"; ?> result: array(2) { [0]=> string(3) "BOB" ["USER"]=> string(3) "BOB" }