FM / privileges

/usr/share/phpmyadmin/templates/database/privileges/

/usr/share/phpmyadmin/templates/database/privileges

Name	Size	Mode	Actions
index.twig	6150	0644	edit dl rm

Edit: /usr/share/phpmyadmin/templates/database/privileges/index.twig (6150B)

{% if is_superuser %}
  <form id="usersForm" action="{{ url('/server/privileges') }}">
    {{ get_hidden_inputs(db) }}

<div class="w-100">
      <fieldset>
        <legend>
          {{ get_icon('b_usrcheck') }}
          {{ 'Users having access to "%s"'|trans|format('<a href="' ~ database_url ~ get_common({'db': db}, '&') ~ '">' ~ db|escape('html') ~ '</a>')|raw }}
        </legend>

<div class="table-responsive jsresponsive">
          <table class="table table-light table-striped table-hover w-auto">
            <thead class="thead-light">
              <tr>
                <th></th>
                <th scope="col">{% trans 'User name' %}</th>
                <th scope="col">{% trans 'Host name' %}</th>
                <th scope="col">{% trans 'Type' %}</th>
                <th scope="col">{% trans 'Privileges' %}</th>
                <th scope="col">{% trans 'Grant' %}</th>
                <th scope="col" colspan="2">{% trans 'Action' %}</th>
              </tr>
            </thead>

<tbody>
              {% for privilege in privileges %}
                {% set privileges_amount = privilege.privileges|length %}
                <tr>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    <input type="checkbox" class="checkall" name="selected_usr[]" id="checkbox_sel_users_{{ loop.index0 }}" value="
                        {{- privilege.user ~ '&amp;#27;' ~ privilege.host }}">
                  </td>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    {% if privilege.user is empty %}
                      <span class="text-danger">{% trans 'Any' %}</span>
                    {% else %}
                      {{ privilege.user }}
                    {% endif %}
                  </td>
                  <td{% if privileges_amount > 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}>
                    {{ privilege.host }}
                  </td>
                  {% for priv in privilege.privileges %}
                    <td>
                      {% if priv.type == 'g' %}
                        {% trans 'global' %}
                      {% elseif priv.type == 'd' %}
                        {% if priv.database == db|replace({'_': '\\_', '%': '\\%'}) %}
                          {% trans 'database-specific' %}
                        {% else %}
                          {% trans 'wildcard' %}: <code>{{ priv.database }}</code>
                        {% endif %}
                      {% elseif priv.type == 'r' %}
                        {% trans 'routine' %}
                      {% endif %}
                    </td>
                    <td>
                      <code>
                        {% if priv.type == 'r' %}
                          {{ priv.routine }}
                          ({{ priv.privileges|join(', ')|upper }})
                        {% else %}
                          {{ priv.privileges|join(', ')|raw }}
                        {% endif %}
                      </code>
                    </td>
                    <td>
                      {{ priv.has_grant ? 'Yes'|trans : 'No'|trans }}
                    </td>
                    <td>
                      {% if is_grantuser %}
                        <a class="edit_user_anchor" href="{{ url('/server/privileges', {
                          'username': privilege.user,
                          'hostname': privilege.host,
                          'dbname': priv.database != '*' ? priv.database,
                          'tablename': '',
                          'routinename': priv.routine ?? ''
                        }) }}">
                          {{ get_icon('b_usredit', 'Edit privileges'|trans) }}
                        </a>
                      {% endif %}
                    </td>
                    <td class="text-center">
                      <a class="export_user_anchor ajax" href="{{ url('/server/privileges', {
                        'username': privilege.user,
                        'hostname': privilege.host,
                        'export': true,
                        'initial': ''
                      }) }}">
                        {{ get_icon('b_tblexport', 'Export'|trans) }}
                      </a>
                    </td>
                  </tr>
                    {% if privileges_amount > 1 %}
                      <tr class="noclick">
                    {% endif %}
                  {% endfor %}
              {% else %}
                <tr>
                  <td colspan="7">
                    {% trans 'No user found.' %}
                  </td>
                </tr>
              {% endfor %}
            </tbody>
          </table>
        </div>

<div class="floatleft">
          <img class="selectallarrow" src="{{ theme_image_path }}arrow_{{ text_dir }}.png" alt="
            {%- trans 'With selected:' %}" width="38" height="22">
          <input type="checkbox" id="usersForm_checkall" class="checkall_box" title="{% trans 'Check all' %}">
          <label for="usersForm_checkall">{% trans 'Check all' %}</label>
          <em class="with-selected">{% trans 'With selected:' %}</em>
          <button class="btn btn-link mult_submit" type="submit" name="submit_mult" value="export" title="{% trans 'Export' %}">
            {{ get_icon('b_tblexport', 'Export'|trans) }}
          </button>
        </div>
      </fieldset>
    </div>
  </form>
{% else %}
  {{ 'Not enough privilege to view users.'|trans|error }}
{% endif %}

{% if is_createuser %}
  <div class="row">
    <div class="col-12">
      <fieldset id="fieldset_add_user">
        <legend>{% trans %}New{% context %}Create new user{% endtrans %}</legend>
        <a id="add_user_anchor" href="{{ url('/server/privileges', {
          'adduser': true,
          'dbname': db
        }) }}" rel="{{ get_common({'checkprivsdb': db}) }}">
          {{ get_icon('b_usradd', 'Add user account'|trans) }}
        </a>
      </fieldset>
    </div>
  </div>
{% endif %}

{% if is_superuser %}

{{ get_icon('b_usrcheck') }} {{ 'Users having access to "%s"'|trans|format('' ~ db|escape('html') ~ '')|raw }}

{% for privilege in privileges %} {% set privileges_amount = privilege.privileges|length %} 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}> 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}> {% if privilege.user is empty %} {% trans 'Any' %} {% else %} {{ privilege.user }} {% endif %} 1 %} class="align-middle" rowspan="{{ privileges_amount }}"{% endif %}> {{ privilege.host }} {% for priv in privilege.privileges %} {% if privileges_amount > 1 %} {% endif %} {% endfor %} {% else %} {% endfor %}

	{% trans 'User name' %}	{% trans 'Host name' %}	{% trans 'Type' %}	{% trans 'Privileges' %}	{% trans 'Grant' %}	{% trans 'Action' %}
{% if priv.type == 'g' %} {% trans 'global' %} {% elseif priv.type == 'd' %} {% if priv.database == db\|replace({'_': '\\_', '%': '\\%'}) %} {% trans 'database-specific' %} {% else %} {% trans 'wildcard' %}: `{{ priv.database }}` {% endif %} {% elseif priv.type == 'r' %} {% trans 'routine' %} {% endif %}	`{% if priv.type == 'r' %} {{ priv.routine }} ({{ priv.privileges\|join(', ')\|upper }}) {% else %} {{ priv.privileges\|join(', ')\|raw }} {% endif %}`	{{ priv.has_grant ? 'Yes'\|trans : 'No'\|trans }}	{% if is_grantuser %} {{ get_icon('b_usredit', 'Edit privileges'\|trans) }} {% endif %}	{{ get_icon('b_tblexport', 'Export'\|trans) }}
{% trans 'No user found.' %}

{% trans 'Check all' %} {% trans 'With selected:' %}

{% else %} {{ 'Not enough privilege to view users.'|trans|error }} {% endif %} {% if is_createuser %}

{% trans %}New{% context %}Create new user{% endtrans %} {{ get_icon('b_usradd', 'Add user account'|trans) }}

{% endif %}