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 1qNvUw-006M5k-EZ for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 13:21:14 +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 1qNvUu-00AY7y-V8 for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 13:21:12 +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 1qNvUu-00AY7q-Ke for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 13:21:12 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNvUs-001IHP-1T for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 13:21:11 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-c84fd44593aso4737753276.0 for ; Mon, 24 Jul 2023 06:21:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690204869; x=1690809669; 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=TI4sSOVlFzeJA3zKZGjx6NrmvXMCDJQnIMNNqVxLBfE=; b=FC5YcE79maTAxNdmx+0F1dvcBGbkyVvMCMdQ/+cMyD5PPFYaHRJaDiH8u/c3PSS5qa IBAAI0rxZO6tYXgfS7+M6Bv2VVA348XWc9Yjurgqfi1Gm1YyIbDaK525aAyif/aZjwYD P+RASzLLT5pqp/2vtzl1cWtk+FnTizy97tY8qYn2JUPLlj/Lrl9CeU4WcB6sflTL0jMN p+1UXxHE3e8Nt7/S5pqzNgD5JignZ4nxjYxMRycwW3a+AtICdooXCH6yJCPG8iN6ZCYo jttQ5Aexj59qeanlDBBNuUZ+xCq6PV04h5Wr81K9KHC5T4AZf4CUFrU0/HmiOWSRpa59 3JjQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690204869; x=1690809669; 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=TI4sSOVlFzeJA3zKZGjx6NrmvXMCDJQnIMNNqVxLBfE=; b=LBL/JWOZ8agydFEBHt//gFgODsT95BGwgvoeJ1231C89KNb3qPaCR/p3Mfhrs5Ukay S/BlX88Y9qKPSD/8JGTACyolgiakUY8IeNpXPynZ8lzCCFt+4CV8xu/1aw3Sj3TiNAzC EkuNc3wTpjTXvJY/2OcrpFMKTj7imq7w9Otc3+qKZN6/OasxFuETw4cT9X+G59VYBPEV BoIREMD/imsvicQ76Bv+zQzW+4uhy/2uxwb9SV5KmGHcEVMYox27fVfZ3f8fJ2vHSzJt 8JWVgUp1TkWdisFFUX5LxreJ1Lco3ScujZVJSWX+d/sKQJQRUchvcBDVTXIq6MP18H7n OBZA== X-Gm-Message-State: ABy/qLYzZEsJLxCCPiTvSNDpgbLRYa8cxRZBeQfG0csHrZ+m+Qt3R0xX seQaToz0Oq7FR2cOvF5l9gJQE+hI9D4= X-Google-Smtp-Source: APBJJlGKCHQvCWkSaNdU6sJeM6zL6rXR8HCmEj57eK822Kn2Ve5LPpKJjEIHgvB/EAinUWaD3zCVyw== X-Received: by 2002:a5b:e8e:0:b0:d11:97d5:e8a8 with SMTP id z14-20020a5b0e8e000000b00d1197d5e8a8mr1869632ybr.49.1690204868903; Mon, 24 Jul 2023 06:21:08 -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 e75-20020a25504e000000b00d05bb67965dsm1575635ybb.8.2023.07.24.06.21.08 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jul 2023 06:21:08 -0700 (PDT) Message-ID: <85b5b466-1efd-fb89-8686-08e5df88a00b@gmail.com> Date: Mon, 24 Jul 2023 08:21:08 -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: From: Ron In-Reply-To: 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 08:15, Kaushal Shriyan wrote: > Hi, > > I am running postgresql15-server 15.3 on Red Hat Enterprise Linux > release 8.7 (Ootpa) > > # rpm -qa | grep -i post > postgresql15-server-15.3-2PGDG.rhel8.x86_64 > postgresql15-libs-15.3-2PGDG.rhel8.x86_64 > postgresql15-15.3-2PGDG.rhel8.x86_64 > # > > $psql > psql (15.3) > Type "help" for help. > > postgres=# GRANT ALL PRIVILEGES ON DATABASE cbdevdb TO cbdevdbadmin; > postgres=# \du > List of roles > Role name | Attributes > | Member of > --------------+------------------------------------------------------------+----------- > cbdevdbadmin | | {} > postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} > > postgres=# > > Am I missing something? Please suggest. Thanks in advance. No, you aren't.  Role attributes are not the same as table privileges. -- Born in Arizona, moved to Babylonia.