xref: /PHP-7.3/ext/oci8/tests/password.phpt (revision a2c0f872)
1--TEST--
2oci_password_change() for non-persistent connections
3--SKIPIF--
4<?php
5if (!extension_loaded('oci8')) die("skip no oci8 extension");
6require(dirname(__FILE__)."/details.inc");
7if (empty($dbase)) die ("skip requires database connection string be set");
8if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user");
9if ($test_drcp) die("skip password change not supported in DRCP Mode");
10?>
11--FILE--
12<?php
13
14require(dirname(__FILE__)."/connect.inc");
15
16$stmtarray = array(
17	"drop user testuser_pw cascade",
18	"create user testuser_pw identified by testuserpwd",
19    "grant connect, create session to testuser_pw"
20);
21
22oci8_test_sql_execute($c, $stmtarray);
23
24
25// Connect and change the password
26$c1 = oci_connect("testuser_pw", "testuserpwd", $dbase);
27var_dump($c1);
28$rn1 = (int)$c1;
29
30oci_password_change($c1, "testuser_pw", "testuserpwd", "testuserpwd2");
31
32// Second connect should return a new resource because the hash string will be different from $c1
33$c2 = oci_connect("testuser_pw", "testuserpwd2", $dbase);
34var_dump($c2);
35$rn2 = (int)$c2;
36
37// Despite using the old password this connect should succeed and return the original resource
38$c3 = oci_connect("testuser_pw", "testuserpwd", $dbase);
39var_dump($c3);
40$rn3 = (int)$c3;
41
42// Connections should differ
43if ($rn1 == $rn2) {
44	echo "First and second connections share a resource: Not OK\n";
45	var_dump($c1);
46}
47else {
48	echo "First and second connections are different: OK\n";
49}
50
51// Connections should be the same
52if ($rn1 == $rn3) {
53	echo "First and third connections share a resource: OK\n";
54}
55else {
56	echo "First and third connections are different: Not OK\n";
57	var_dump($c1);
58	var_dump($c2);
59}
60
61echo "Done\n";
62
63?>
64--CLEAN--
65<?php
66
67require(dirname(__FILE__)."/connect.inc");
68
69$stmtarray = array(
70    "drop user testuser_pw cascade"
71);
72
73oci8_test_sql_execute($c, $stmtarray);
74
75?>
76--EXPECTF--
77resource(%d) of type (oci8 connection)
78resource(%d) of type (oci8 connection)
79resource(%d) of type (oci8 connection)
80First and second connections are different: OK
81First and third connections share a resource: OK
82Done
83