Project

General

Profile

Actions

Bug #265

closed

Missing permission for sequences on database clone

Added by Alexander Watzinger over 10 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Category:
Data import/export
Target version:
Start date:
2014-06-10
Estimated time:
Found in version:

Description

Database: openatla_main_db_clone2014_june_alex
User: openatla_watzingeralex

php export.php

PHP Warning:  pg_query(): Query failed: ERROR:  permission denied for sequence tbl_properties_tbl_properties_uid_seq in /home/alex/projects/openatlas/export.php on line 51                   
PHP Stack trace:                                                                                                                                                                              
PHP   1. {main}() /home/alex/projects/openatlas/export.php:0                                                                                                                                  
PHP   2. pg_query() /home/alex/projects/openatlas/export.php:51                                                                                                                               
PHP Warning:  pg_query(): Query failed: ERROR:  permission denied for sequence tbl_classes_tbl_classes_uid_seq in /home/alex/projects/openatlas/export.php on line 52                         
PHP Stack trace:                                                                                                                                                                              
PHP   1. {main}() /home/alex/projects/openatlas/export.php:0                                                                                                                                  
PHP   2. pg_query() /home/alex/projects/openatlas/export.php:52                                                                                                                               
PHP Warning:  pg_query(): Query failed: ERROR:  permission denied for sequence tbl_links_links_uid_seq in /home/alex/projects/openatlas/export.php on line 53                                 
PHP Stack trace:                                                                                                                                                                              
PHP   1. {main}() /home/alex/projects/openatlas/export.php:0                                                                                                                                  
PHP   2. pg_query() /home/alex/projects/openatlas/export.php:53
PHP Warning:  pg_query(): Query failed: ERROR:  permission denied for sequence tbl_classes_tbl_classes_uid_seq in /home/alex/projects/openatlas/export.php on line 62
PHP Stack trace:
PHP   1. {main}() /home/alex/projects/openatlas/export.php:0
PHP   2. pg_query() /home/alex/projects/openatlas/export.php:62
ERROR:  permission denied for sequence tbl_classes_tbl_classes_uid_seq line: 62
Actions #1

Updated by Stefan Eichert over 10 years ago

folgendes gemacht:
GRANT ALL ON ALL SEQUENCES IN SCHEMA openatlas TO openatla_watzingeralex;

Hoffe es geht jetzt
lg St.

Actions #2

Updated by Alexander Watzinger over 10 years ago

  • Status changed from Assigned to Closed

is working now

Actions #3

Updated by Alexander Watzinger over 9 years ago

  • Category set to 51
Actions #4

Updated by Alexander Watzinger over 9 years ago

  • Project changed from 9 to OpenAtlas
  • Category changed from 51 to 52
Actions #5

Updated by Alexander Watzinger over 9 years ago

  • Target version set to Alpha
Actions #6

Updated by Alexander Watzinger over 5 years ago

  • Category changed from 52 to Data import/export
Actions

Also available in: Atom PDF