[GeoNetwork-users] batch privilege change (maybe in postGIS ??)

GeoNetwork GeoNetwork User
,
1

Hi to all

I have a GN 2.10.3 using a PostGIS database,

I can see the metadata tables and contents inside the data, and even
manipulate the configuration on the database (cooolll!!!)

My current issue is that I have some 50 000 records and I would like to
know how to change the privileges indicate that all records can be published

In the Privileges GUI for the record(s) I just tick on Publish and group All

I was wondering if records permissions are stored in the Database, since
I haven't found any permission columns aside from ownership

Question, how are these privileges stored ??? DB some JAVA code and how
can I do it??? I know I could do it using the service interface

Thank you
Jorge

--
ISRIC - World Soil Information Post: PO box 353, 6700 AJ, Wageningen,
The Netherlands Visiting Address: Droevendaalsesteeg 3, 6708 PB
Wageningen (Bdg. 101), Office: C.013 Office Phone: +31 (0) 317 4 83715
Mobile Phone: +31 (0) 613 9 06950 OpenPGPKey: 0xA3D0065A

2

Hi Jorge,

I think you could find the privileges data in the operationsallowed table.
This refer to a group, and an operation that could be (view, edit, map
etc..).

On Wed, Jun 25, 2014 at 3:12 PM, Jorge de Jesus <jorge.mendesdejesus@anonymised.com...>
wrote:

Hi to all

I have a GN 2.10.3 using a PostGIS database,

I can see the metadata tables and contents inside the data, and even
manipulate the configuration on the database (cooolll!!!)

My current issue is that I have some 50 000 records and I would like to
know how to change the privileges indicate that all records can be
published

In the Privileges GUI for the record(s) I just tick on Publish and group
All

I was wondering if records permissions are stored in the Database, since
I haven't found any permission columns aside from ownership

Question, how are these privileges stored ??? DB some JAVA code and how
can I do it??? I know I could do it using the service interface

Thank you
Jorge

--
ISRIC - World Soil Information Post: PO box 353, 6700 AJ, Wageningen,
The Netherlands Visiting Address: Droevendaalsesteeg 3, 6708 PB
Wageningen (Bdg. 101), Office: C.013 Office Phone: +31 (0) 317 4 83715
Mobile Phone: +31 (0) 613 9 06950 OpenPGPKey: 0xA3D0065A

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
Best Open Source Mac Front-Ends 2024
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Florent Gravin
Camptocamp - Chambéry
0479444492

3

Hi Florent

You were correct and with some SQL I managed to change things :slight_smile:

Thank for the help

Jorge

On 06/25/2014 05:33 PM, Florent Gravin wrote:

Hi Jorge,

I think you could find the privileges data in the operationsallowed table.
This refer to a group, and an operation that could be (view, edit, map
etc..).

On Wed, Jun 25, 2014 at 3:12 PM, Jorge de Jesus
<jorge.mendesdejesus@anonymised.com <mailto:jorge.mendesdejesus@anonymised.com>> wrote:

    Hi to all

    I have a GN 2.10.3 using a PostGIS database,

    I can see the metadata tables and contents inside the data, and even
    manipulate the configuration on the database (cooolll!!!)

    My current issue is that I have some 50 000 records and I would like to
    know how to change the privileges indicate that all records can be
    published

    In the Privileges GUI for the record(s) I just tick on Publish and
    group All

    I was wondering if records permissions are stored in the Database, since
    I haven't found any permission columns aside from ownership

    Question, how are these privileges stored ??? DB some JAVA code and how
    can I do it??? I know I could do it using the service interface

    Thank you
    Jorge

    --
    ISRIC - World Soil Information Post: PO box 353, 6700 AJ, Wageningen,
    The Netherlands Visiting Address: Droevendaalsesteeg 3, 6708 PB
    Wageningen (Bdg. 101), Office: C.013 Office Phone: +31 (0) 317 4 83715
    Mobile Phone: +31 (0) 613 9 06950 OpenPGPKey: 0xA3D0065A

    ------------------------------------------------------------------------------
    Open source business process management suite built on Java and Eclipse
    Turn processes into business applications with Bonita BPM Community
    Edition
    Quickly connect people, data, and systems into organized workflows
    Winner of BOSSIE, CODIE, OW2 and Gartner awards
    http://p.sf.net/sfu/Bonitasoft
    _______________________________________________
    GeoNetwork-users mailing list
    GeoNetwork-users@lists.sourceforge.net
    <mailto:GeoNetwork-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/geonetwork-users
    GeoNetwork OpenSource is maintained at
    http://sourceforge.net/projects/geonetwork

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
ISRIC - World Soil Information Post: PO box 353, 6700 AJ, Wageningen,
The Netherlands Visiting Address: Droevendaalsesteeg 3, 6708 PB
Wageningen (Bdg. 101), Office: C.013 Office Phone: +31 (0) 317 4 83715
Mobile Phone: +31 (0) 613 9 06950 OpenPGPKey: 0xA3D0065A