Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwgxV-003SDj-7e for pgsql-general@arkaria.postgresql.org; Tue, 16 Apr 2024 11:26:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rwgxT-00394R-QT for pgsql-general@arkaria.postgresql.org; Tue, 16 Apr 2024 11:26:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwgxT-00392m-DA for pgsql-general@lists.postgresql.org; Tue, 16 Apr 2024 11:26:39 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rwgxQ-0037uR-RM for pgsql-general@lists.postgresql.org; Tue, 16 Apr 2024 11:26:38 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-516d756eb74so5152466e87.3 for ; Tue, 16 Apr 2024 04:26:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713266794; x=1713871594; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+63WKmhYm8aC1h54UYbdvYA3h7ZLOOrgu4BIOu9ub/g=; b=i5je4Z/sRBdYKzL2APnVNufqI4B8pp1+AJIIszv5m8Q/6t+4TDbMNhmGLRVU7tt+CW 2LizMvQlzHWpOud1uZv1vTgha6gzQ9JwfGETMqm+TBy3+5ODZ2BXjbwWQ4bnrD8s1Ncq x4eg5HvYenbfjerewGCX7xZvnfC3kqXjpbhzHsRRSRLa+jWt2Qeu4j9EBm5eD1hdWdyF APAY4CbjVEdmklIRrmwNZa7qZhXg27WJV6kMVm/2rhOwAGkjaPyWuEUvT7F0kjsMyXQg WJIo+kM6eRlOVLRMYSsHnYABWB2d+Vl3nemGaxSi/JnrU29O4SuaN7Tl7pLUjtmfYfby kR4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713266794; x=1713871594; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=+63WKmhYm8aC1h54UYbdvYA3h7ZLOOrgu4BIOu9ub/g=; b=NGRpbZXAiEPjN27/+oHqkQJskM1XNHjBSbsVAqEZmEuLvigyvXQY7TFy3QsLyWsKPQ lLxQJvgliyOKKK7Ht7EfiTMHVIWTSEmDrOh/W7sP6crnmKrU0rfVXme1q8IcwQlWJUvP 689ezlpa4+3eZtNrJIZ9oEGhQpHOsOJWtG1NHGmco0XalpJgSBZUPTshb78M2X5fSwfc Qo50uay+wM55oKH67xoCAYyjkuc82WYmaALZibUM7cWO6FFWKHH7BmKBfsDyi3ujN86F m4T+Gtrt5/sHfP32xpyesdZv6dgt+S1rXnAl+B7kTjYAB4Kv3Eaz6SSct7I5e8qX3gtv TURg== X-Gm-Message-State: AOJu0YxPOBfEcVfx6Rk747Y3eu6a8NspHfiFFb5vs719SsBz4+UzU1VT dg9mDeCnBxfANrxzvkWgU23rdLWb5zq5fbCuup9W/H8yLDp7OU7BKLcgdFwsY8yAlZKcPZdNfe0 g9L8f0UN3UTqR2rztmHqA9ljiKRE= X-Google-Smtp-Source: AGHT+IG1HmDJcloNUQVKdhQkLWxjiBpeaIjONYiv29ywTbRK8gPowq3QYWDi9g/sq58OeAR3w/wsTbbPRicdeJu9vaU= X-Received: by 2002:ac2:548a:0:b0:518:9258:527e with SMTP id t10-20020ac2548a000000b005189258527emr7564838lfk.62.1713266794201; Tue, 16 Apr 2024 04:26:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Tue, 16 Apr 2024 23:26:22 +1200 Message-ID: Subject: Re: Assistance needed for the query execution in non-public schema To: Sasmit Utkarsh Cc: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 16 Apr 2024 at 23:00, Sasmit Utkarsh wrote: > msshctd=> SELECT setval(pg_get_serial_sequence('mqa_flfo_cstr', 'id'), coalesce(MAX(id), 1)) from mqa_flfo_cstr; > ERROR: permission denied for sequence mqa_flfo_cstr_id_seq > msshctd=> SELECT setval(pg_get_serial_sequence('mqa_ffp_nval', 'id'), coalesce(MAX(id), 1)) from mqa_ffp_nval; > ERROR: permission denied for sequence mqa_ffp_nval_id_seq > GRANT USAGE, ALTER ON SEQUENCE mqa_flfo_cstr_id_seq TO shc_uadmin; > ERROR: unrecognized privilege type "alter" SQL state: 42601 According to our documentation for setval(): "This function requires UPDATE privilege on the sequence." https://www.postgresql.org/docs/current/functions-sequence.html David