Bugzilla – Attachment 148966 Details for
Bug 32968
Create granular permissions for ERM
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32968: ERM granular permissions - DB specific
Bug-32968-ERM-granular-permissions---DB-specific.patch (text/plain), 3.26 KB, created by
PTFS Europe Sandboxes
on 2023-03-30 08:45:17 UTC
(
hide
)
Description:
Bug 32968: ERM granular permissions - DB specific
Filename:
MIME Type:
Creator:
PTFS Europe Sandboxes
Created:
2023-03-30 08:45:17 UTC
Size:
3.26 KB
patch
obsolete
>From 5b87687573346969e4af3059d054d39e0bfc5667 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >Date: Wed, 1 Mar 2023 11:57:11 +0000 >Subject: [PATCH] Bug 32968: ERM granular permissions - DB specific > >Signed-off-by: Jonathan Field <jonathan.field@ptfs-europe.com> >--- > .../data/mysql/atomicupdate/bug_32968.pl | 27 +++++++++++++++++++ > .../data/mysql/mandatory/userpermissions.sql | 7 ++++- > 2 files changed, 33 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_32968.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_32968.pl b/installer/data/mysql/atomicupdate/bug_32968.pl >new file mode 100644 >index 0000000000..a19d3afcf3 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_32968.pl >@@ -0,0 +1,27 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "32968", >+ description => "Create granular permissions for ERM", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ >+ >+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (28, 'erm_admin', 'Create, edit and delete all ERM related content') }); >+ say $out "Added new permission 'erm_admin'"; >+ >+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (28, 'erm_show', 'Read-only permission for all ERM related content') }); >+ say $out "Added new permission 'erm_show'"; >+ >+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (28, 'erm_licensing', 'Create, edit and delete licenses') }); >+ say $out "Added new permission 'erm_licensing'"; >+ >+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (28, 'erm_agreement', 'Create, edit and delete agreements. Grants read-only access to licenses and eHoldings') }); >+ say $out "Added new permission 'erm_agreement'"; >+ >+ $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (28, 'erm_eholdings', 'Create, edit and delete EHoldings local titles and local packages. Grants read-only access to agreements') }); >+ say $out "Added new permission 'erm_eholdings'"; >+ >+ }, >+}; >\ No newline at end of file >diff --git a/installer/data/mysql/mandatory/userpermissions.sql b/installer/data/mysql/mandatory/userpermissions.sql >index 7b6955de44..2f52e0da59 100644 >--- a/installer/data/mysql/mandatory/userpermissions.sql >+++ b/installer/data/mysql/mandatory/userpermissions.sql >@@ -148,5 +148,10 @@ INSERT INTO permissions (module_bit, code, description) VALUES > (25, 'cashup', 'Perform cash register cashup action'), > (25, 'takepayment', 'Access the point of sale page and take payments'), > (26, 'manage_problem_reports', 'Manage OPAC problem reports'), >- (27, 'manage_recalls', 'Manage recalls for patrons') >+ (27, 'manage_recalls', 'Manage recalls for patrons'), >+ (28, 'erm_admin', 'Create, edit and delete all ERM related content'), >+ (28, 'erm_show', 'Read-only permission for all ERM related content'), >+ (28, 'erm_licensing', 'Create, edit and delete licenses'), >+ (28, 'erm_agreement', 'Create, edit and delete agreements. Grants read-only access to licenses and eHoldings'), >+ (28, 'erm_eholdings', 'Create, edit and delete EHoldings local titles and local packages. Grants read-only access to agreements') > ; >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 32968
:
146698
|
147466
|
147510
|
147511
|
147513
|
147514
|
147515
|
147516
|
147517
|
147518
|
147559
|
148797
|
148798
|
148799
|
148800
|
148801
|
148802
|
148803
|
148804
|
148959
|
148960
|
148961
|
148962
|
148963
|
148964
|
148965
|
148966
|
149423
|
149424
|
149425
|
149426
|
149427
|
149428
|
149429
|
149430
|
150060
|
150061
|
150062
|
150063
|
150064
|
150065
|
150066
|
150067