#1316: Ticket/Report view permissions dependent on owner (or user logged in)
--------------------------------+-------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: enhancement | Status: new
Priority: normal | Milestone:
Component: ticket system | Version: devel
Severity: normal | Resolution:
Keywords: acl |
--------------------------------+-------------------------------------------
Comment (by [EMAIL PROTECTED]):
I'm also very interested in such feature
as a quick solution i did the following:[[br]]
- users in "group" developer can see all tickets[[br]]
- all other users can only see self created oder assigned tickets. [[br]]
edit all reports below "view tickets" and limit the sql statements to
developer "group", e.g. the "view all tickets" sql should be as follows
(look for the perm keyword):
{{{
SELECT p.value AS __color__,
id AS ticket, summary, component, version, milestone, t.type AS type,
severity,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t, enum p, permission perm
WHERE status IN ('new', 'assigned', 'reopened')
AND p.name = t.priority AND p.type = 'priority' AND perm.action =
'developer' and perm.username='$USER'
ORDER BY p.value, milestone, severity, time
}}}
in trac.ini disable the custom query link, so nobody can create querys
{{{
[components]
trac.ticket.query.* = disabled
}}}
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/1316>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
