Function get_user_server_query

web/pgadmin/utils/server_access.py:122–138

Return a base query for servers accessible to the current user. Includes owned servers + shared servers (visible to all users). The Administrator role does not grant visibility into other users' private servers.

()

def get_user_server_query():
    """Return a base query for servers accessible to the current user.

    Includes owned servers + shared servers (visible to all users).

    The Administrator role does not grant visibility into other
    users' private servers.
    """
    if not config.SERVER_MODE:
        return Server.query

    return Server.query.filter(
        or_(
            Server.user_id == current_user.id,
            Server.shared
        )
    )