Closed Bug 819020 Opened 13 years ago Closed 13 years ago

permission denied for relation product_crash_ratio

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: kairo, Assigned: selenamarie)

Details

(Whiteboard: [qa-])

Attachments

(1 file)

Grants for analyst user
4.00 KB, text/x-sql
Details
Today, after the prod update to PostgreSQL 9.2, my scripts are throwing this error: Warning: pg_query(): Query failed: ERROR: permission denied for relation product_crash_ratio in /mnt/crashanalysis/rkaiser/crash-report-tools/get-socorrodata.php on line 137 There's a second similarly named view, both were made for metrics to use use from the analyst user, which is the same I'm using to access this one as well.
Assignee: nobody → sdeckelmann
Whiteboard: [qa-]
Target Milestone: --- → 31
Applied role updates to prod, and committed new version of schema.sql to DB. Two permission settings were missing and are now restored. Thanks for filing the bug!
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Verified, my scripts now run without an error.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: