shinbuntu / db-user

     *

     * @return bool TRUE on success or FALSE on failure.

     */

    public function grantPrivileges($username, $privileges = self::PRIVILEGE_USAGE, $database = '*', $table = '*')

    {

        $sqlQuery = $this->changePrivilegesQuery(

            self::PRIVILEGE_STATEMENT_GRANT,

            $username,

            $privileges,

            $database,

            $table

        );

        return $this->connection->exec($sqlQuery) !== false;

    }

    /**

     * Revoke privileges to mysql user.

     *

     * @return bool TRUE on success or FALSE on failure.

     */

    public function revokePrivileges($username, $privileges = self::PRIVILEGE_USAGE, $database = '*', $table = '*')

    {

        $sqlQuery = $this->changePrivilegesQuery(

            self::PRIVILEGE_STATEMENT_REVOKE,

            $username,

            $privileges,

            $database,

            $table

        );

        return $this->connection->exec($sqlQuery) !== false;

    }

    /**

     * Flush privileges.