Обсуждение: Create & Alter Schema Permissions for a Login role in Postgresql database
I have a Postgresql database with 3 Schemas (2 user defined and 1 public). I have script that takes backup of the user defined schema's and then drops the schema's. Now after doing some operations I want to restore the user defined schemas from the schema backup(schema_backup.out). When I execute cat schema_backup.out | psql xx_db_name_xx I am getting the following error message ERROR: permission denied for database xx_db_name_xx ERROR: schema "aaaa" does not exist ERROR: permission denied for database xx_db_name_xx ERROR: schema "bbbb" does not exist ERROR: must be owner of database xx_db_name_xx When I execute the same command as Admin user its executing just fine. But, when I execute as a 'xxxxxx' user its failing. Can someone guide me, what permissions/rights should be added to 'xxxxxx' to restore the schema? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Create-Alter-Schema-Permissions-for-a-Login-role-in-Postgresql-database-tp5135000p5135000.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Re: Create & Alter Schema Permissions for a Login role in Postgresql database
От
Guillaume Lelarge
Дата:
On Tue, 2012-01-10 at 11:33 -0800, Tripura wrote: > I have a Postgresql database with 3 Schemas (2 user defined and 1 public). > > I have script that takes backup of the user defined schema's and then drops > the schema's. > > Now after doing some operations I want to restore the user defined schemas > from the schema backup(schema_backup.out). > > When I execute > cat schema_backup.out | psql xx_db_name_xx > > I am getting the following error message > ERROR: permission denied for database xx_db_name_xx > ERROR: schema "aaaa" does not exist > ERROR: permission denied for database xx_db_name_xx > ERROR: schema "bbbb" does not exist > ERROR: must be owner of database xx_db_name_xx > > When I execute the same command as Admin user its executing just fine. But, > when I execute as a 'xxxxxx' user its failing. > > Can someone guide me, what permissions/rights should be added to 'xxxxxx' to > restore the schema? > He needs CREATE permission on the database. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org