Date: Fri, 28 Jul 2017 13:43:22 -0700 (MST)
From: srilinux <srilinux09@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1501274602412-5973259.post@n3.nabble.com>
Subject: created database but access is not copied ? any suggestions
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Hi All

I have created the below standby database using the below command

CREATE DATABASE standby OWNER admin TABLESPACE assembly;  

this worked but the assembly database has privileges which are not copied to
standby server , is there any thing that need to be added in the create
syntax or do after the standby db is created ?

Below is the list , how to grant access privileges

postgres=# \list
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access
privileg
es
-----------+----------+----------+-------------+-------------+------------------
-----
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |


 *standby   | 	admin  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |*

*assembly | admin  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/admin
    +
           |          |          |             |             | admin=CTc/adm
in*


 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
    +
           |          |          |             |             |
postgres=CTc/post
gres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
    +
           |          |          |             |             |
postgres=CTc/post
gres
 
(5 rows)


--
View this message in context: http://www.postgresql-archive.org/created-database-but-access-is-not-copied-any-suggestions-tp5973259.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql