nextcloud / server

		$query='SELECT count(*) FROM user_role_privs, role_sys_privs'

			." WHERE user_role_privs.granted_role = role_sys_privs.role AND privilege = 'CREATE ROLE'";

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

		if (!$stmt) {

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

			$entry .= $this->trans->t('Offending command was: "%s"', array($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"', array($this->getLastError($connection))) . '<br />';

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

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

		}

		oci_execute($stmt);

	}

		$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"', array($this->getLastError($connection))) . '<br />';

			$entry .= $this->trans->t('Offending command was: "%s"', array($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"', array($this->getLastError($connection))) . '<br />';

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

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

		}

		if(! oci_fetch_row($stmt)) {

			//user does not exists let's create it :)

			//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"', array($this->getLastError($connection))) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s"', array($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"', array($this->getLastError($connection))) . '<br />';

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

					array($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);

		} 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"', array($this->getLastError($connection))) . '<br />';

				$entry .= $this->trans->t('Offending command was: "%s"', array($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"', array($this->getLastError($connection))) . '<br />';

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

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

			}

		}

		// grant necessary roles

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

		// grant necessary roles

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

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

		if (!$stmt) {

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

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

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

		}

		$result = oci_execute($stmt);

		if(!$result) {

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

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

		}

		$result = oci_execute($stmt);

		if(!$result) {

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

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

				array($query, $name, $password)) . '<br />';

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

		}

	}

	/**