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 1qNwuk-006PlU-DA for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 14:51:58 +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 1qNwui-00BCZm-TY for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 14:51:56 +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 1qNwui-00BCZd-Iw for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 14:51:56 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNwug-001JnV-6A for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 14:51:55 +0000 Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-3a3373211a1so2664226b6e.0 for ; Mon, 24 Jul 2023 07:51:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690210313; x=1690815113; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=juSTr0rbrv9y5WcpAyW8UFPLxeeMNQcKBRi0r7FuepU=; b=KqZHOG88sYUPrekDLVSTTkz2BsO8QtiQuPfYW18TfuYNcGrg4TYskKNqIlYh97XITq +UebYKWlOdswtuUON5UY+Mv95lvy3FzNqiSp8TJ5rl5aTSL30dKlMVi2Sc8VrJv2lCcP j4q5uGAA8FIuU3+Nwxci3aTLSYu5cKbOkK/Doxu/HOiY0irEua8Vvhbl+MH54/yc7DE+ hgsSPdRx8BWXH7fy1aFDoilPR9DotNbHBtdWuCkQhQPYZdq0djC1Wr+4+LDolBVm9F3H FNcA1qiW/1fiPampsACOeYsoTMXG5XQJT5gzTvZmdQFuy8Xm8nH5Rz1VUbSRG+5YLOc5 oY1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690210313; x=1690815113; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=juSTr0rbrv9y5WcpAyW8UFPLxeeMNQcKBRi0r7FuepU=; b=Wgj0ylnjtJlOu3/UMR3jfXZc+g7y81Aj7qW9R2fEMRjHEevSBR7b6KiAPdSWvbCjUi PvDALVIQaVGGd6IPQ1HJeoo3O3gYZvL+TerwOcg3zsOLeJS6lbT5MBlorg4oTdBWfR7g hvee3PzYJ3LJQ5HJwI056hbiX8u38v9AUEQG9ZAk5QjkeIx7+uPnSFRekbQFbLabjVxK 7ziNkVN6cuB90ZwBghWehKGjN/UEma9hRr7R/9UmNphlwcff1/M/Hy6NUHhElDu6bhXh CFlT+0k+zuGCniJmkgqbHEXxsu51vcFW3+LDdCqAbTQ2CY+pohzCu1rJwX8bpbXSzW12 u98Q== X-Gm-Message-State: ABy/qLauPIgNbe+tifYxIx1comJL3cV1u64pr1mN0g7rNEEktZ7VQwgH vhL8TFprlU+f38lUZDVIboPTi52+YIk= X-Google-Smtp-Source: APBJJlEZ/joBQ49VoyrjAepL6Qv/6WHbd0ObJ0e3ukGdEiWweb1w1BZvWAriTmcblQsOQKlBxpZSLQ== X-Received: by 2002:a05:6808:f01:b0:398:34da:daad with SMTP id m1-20020a0568080f0100b0039834dadaadmr13346574oiw.51.1690210313107; Mon, 24 Jul 2023 07:51:53 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:585f:57d8:bb8a:ecd6? ([2600:1700:bd2c:b810:585f:57d8:bb8a:ecd6]) by smtp.googlemail.com with ESMTPSA id e17-20020a056808149100b003a4825088ffsm4126320oiw.51.2023.07.24.07.51.52 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jul 2023 07:51:52 -0700 (PDT) Message-ID: <62d2ad15-5192-0104-ad49-5ff301f5c425@gmail.com> Date: Mon, 24 Jul 2023 09:51:52 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Grant all privileges to user on a database Content-Language: en-US To: "pgsql-general@lists.postgresql.org" References: <85b5b466-1efd-fb89-8686-08e5df88a00b@gmail.com> <1549849.1690207746@sss.pgh.pa.us> From: Ron In-Reply-To: <1549849.1690207746@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/24/23 09:09, Tom Lane wrote: > "David G. Johnston" writes: >> The error message is misleading, you can’t directly create tables in a >> database, you must create them in a schema and the permission to do so is >> granted to the role on the schema, not the database. > The actual server message is going to be just > > ERROR: permission denied for schema public > > I'm not sure where the "Are you sure ..." bit came from, but it wasn't > Postgres. > > Anyway, backing up two steps, it looks like drupal hasn't yet adapted > to the v15 change that removed default create privileges on the public > schema (for security reasons). You might see if a newer drupal release > is available. If not, the best bet would likely be > > GRANT ALL ON SCHEMA public TO public; I'd have naively expected "GRANT ALL ON SCHEMA public TO public; " to be taken care of by "GRANT ALL PRIVILEGES ON DATABASE cbdevdb TO cbdevdbadmin;". -- Born in Arizona, moved to Babylonia.