owncloud / core

		                'CREATE TRIGGER'

		                ) AND a2.admin_option = 'YES')";

		$stmt = \oci_parse($connection, $query);

		if (!$stmt) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		$result = \oci_execute($stmt);

		if ($result) {

			$row = \oci_fetch_row($stmt);

		$stmt = \oci_parse($connection, $query);

		$un = $this->tablePrefix.'users';

		\oci_bind_by_name($stmt, ':un', $un);

		if (!$stmt) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		$result = \oci_execute($stmt);

		if ($result) {

		$password = $this->dbPassword;

		$query = "SELECT * FROM all_users WHERE USERNAME = :un";

		$stmt = \oci_parse($connection, $query);

		if (!$stmt) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		\oci_bind_by_name($stmt, ':un', $name);

		$result = \oci_execute($stmt);

		if (!$result) {

		}

		\oci_bind_by_name($stmt, ':un', $name);

		$result = \oci_execute($stmt);

		if (!$result) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		if (! \oci_fetch_row($stmt)) {

			//user does not exist, so let's create them :)

			//password must start with alphabetic character in oracle

			$query = 'CREATE USER '.$name.' IDENTIFIED BY "'.$password.'" DEFAULT TABLESPACE '.$this->dbtablespace;

			$stmt = \oci_parse($connection, $query);

			if (!$stmt) {

				$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

				$this->logger->warning($entry, ['app' => 'setup.oci']);

			}

			//oci_bind_by_name($stmt, ':un', $name);

			$result = \oci_execute($stmt);

			if (!$result) {

				$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			}

			//oci_bind_by_name($stmt, ':un', $name);

			$result = \oci_execute($stmt);

			if (!$result) {

				$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s", name: %s, password: %s',

					[$query, $name, $password]) . '<br />';

				$this->logger->warning($entry, ['app' => 'setup.oci']);

			}

		} else { // change password of the existing role

			$query = "ALTER USER :un IDENTIFIED BY :pw";

			$stmt = \oci_parse($connection, $query);

			if (!$stmt) {

		} else { // change password of the existing role

			$query = "ALTER USER :un IDENTIFIED BY :pw";

			$stmt = \oci_parse($connection, $query);

			if (!$stmt) {

				$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

				$this->logger->warning($entry, ['app' => 'setup.oci']);

			}

			\oci_bind_by_name($stmt, ':un', $name);

			\oci_bind_by_name($stmt, ':pw', $password);

			$result = \oci_execute($stmt);

			\oci_bind_by_name($stmt, ':un', $name);

			\oci_bind_by_name($stmt, ':pw', $password);

			$result = \oci_execute($stmt);

			if (!$result) {

				$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

				$this->logger->warning($entry, ['app' => 'setup.oci']);

			}

		}

		// grant necessary roles

		$query = 'GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER TO '.$name;

		// grant necessary roles

		$query = 'GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER TO '.$name;

		$stmt = \oci_parse($connection, $query);

		if (!$stmt) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', [$query]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		$result = \oci_execute($stmt);

		if (!$result) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

		$result = \oci_execute($stmt);

		if (!$result) {

			$entry = $this->trans->t('DB Error: "%s"', [$this->getLastError($connection)]) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s", name: %s, password: %s',

				[$query, $name, $password]) . '<br />';

			$this->logger->warning($entry, ['app' => 'setup.oci']);

		}

	}

	/**