Context Navigation

← Previous Ticket
Next Ticket →

Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.

Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #2204 (closed)

Opened 14 years ago

Closed 14 years ago

Generate script to check all permissions

Reported by:	jamoore	Owned by:	jamoore
Priority:	minor	Milestone:	OMERO-Beta4.2
Component:	ORM	Version:	n.a.
Keywords:	n.a.	Cc:
Resources:	n.a.	Referenced By:	n.a.
References:	n.a.	Remaining Time:	0.0d
Sprint:	2010-06-24 (12)

Description (last modified by jmoore)

The first step in the database upgrade should be something like:

create or replace function check_perms_42()...
check_perms_42('Image', 'Pixels', 'image');
...

where the strings Image/Pixels?/image are retrieved from ExtendedMetadata.getLockChecks

Things to check:

groups don't match (done)
owners don't match (done)
owner is not admin nor still in the group

References

Referenced by:
← User Story (#1750): 4.2 Database upgrade

Change History (14)

comment:1 Changed 14 years ago by jmoore

Remaining Time changed from 0.5 to 0.25

comment:2 Changed 14 years ago by cxallan

Sprint changed from 2010-04-16 (7) to 2010-04-30 (8)

comment:3 Changed 14 years ago by jmoore

Sprint changed from 2010-04-30 (8) to 2010-05-13 (9)

comment:4 Changed 14 years ago by cxallan

Sprint changed from 2010-05-13 (9) to 2010-05-27 (10)

comment:5 Changed 14 years ago by cxallan

Sprint changed from 2010-05-27 (10) to 2010-06-10 (11)

comment:6 Changed 14 years ago by jburel

Sprint changed from 2010-06-10 (11) to 2010-06-24 (12)

comment:7 Changed 14 years ago by jmoore

(In [7346]) OMERO4.1__0 report for OMERO4.2__0 upgrade. (See #2204)

comment:8 Changed 14 years ago by jmoore

Description modified (diff)

comment:9 Changed 14 years ago by jmoore

Several commits have gone to #1750 regarding the permissions checks, and so that ticket should be read closely.

comment:10 Changed 14 years ago by jmoore

Status changed from new to assigned

comment:11 Changed 14 years ago by jmoore

(In [7492]) DB 4.2__0 improvements (See #1750 & #2204, Fix #2565 & #2573)

comment:12 Changed 14 years ago by jmoore

(In [7505]) Scripts updated for PG 8.1 with working upgrade (See #1750 & #2204)

comment:13 Changed 14 years ago by jmoore

(In [7512]) Lowering all group permissions on upgrade (See #1750, #2204)

comment:14 Changed 14 years ago by jmoore

Remaining Time changed from 0.25 to 0
Resolution set to fixed
Status changed from assigned to closed

The report described here has been saved to source:branches/Beta4.2/sql/psql/OMERO4.2__0/omero-4.1-permissions-report.sql and documented for release under http://www.openmicroscopy.org/site/support/omero4/server/db-upgrade-41-to-42

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

Download in other formats: