note 64668 added to function.ibase-pconnect

To make a connection to a firebird database with pconnect many people like to use the SYSDBA, or database owner. example: $dbConnection = ibase_pconnect('path to db','SYSDBA','masterkey'); The above is fine unless you want to login in various user that have different permissions. To use permission make roles in the database, either as the database creator (or SYSDBA) and grant the roles to the various users. If you login with... $dbConnection = ibase_pconnect('path to db', 'USERNAME', 'userpassword'); ...interbase will default your user to the PUBLIC role, which is created when the database is create and usualy has select rights on tables only. To get the proper role you will need to use all the parameters, like this... $user='USERNAME'; $password='userpassword'; $role='MANAGER_HR'; $dbConnection = ibase_pconnect('path to db', $user, $password, '', 0, 3, $role, 0); BTW - The "path to db", is formed like this... --------------------- 'localhost:c:/firebird/test_db/test.fdb' --------------------- reading the interbase material, it states 3 connection methods, PHP appears to have selected the tcp type for us. So you can use localhost, or I suspect(never tested this myself) a ip address. ---- Server IP: 66.163.161.117 Probable Submitter: 69.15.158.9 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.ibase-pconnect.php Edit -- http://master.php.net/note/edit/64668 Del: integrated -- http://master.php.net/note/delete/64668/integrated Del: useless -- http://master.php.net/note/delete/64668/useless Del: bad code -- http://master.php.net/note/delete/64668/bad+code Del: spam -- http://master.php.net/note/delete/64668/spam Del: non-english -- http://master.php.net/note/delete/64668/non-english Del: in docs -- http://master.php.net/note/delete/64668/in+docs Del: other reasons-- http://master.php.net/note/delete/64668 Reject -- http://master.php.net/note/reject/64668 Search -- http://master.php.net/manage/user-notes.php