Bob, grpreassignauthseq is not a table... it's a sequencer. When you create a new register in GRPREASSIGNAUTH table,
When you create a new record in the GRPREASSIGNAUTH table, sequencer indexes the ID.
That insert that I gave you does the same thing as if you did it for Maximo when you press the "New Row" button.
If you have doubts, try it in a test environment.
Regards!
------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------
Original Message:
Sent: 05-23-2024 16:38
From: Bob Kraus
Subject: Unable to view/list/reassign a security group due to grpreassignauth record
Hi, thanks for responding. I understand that this should work, but, the grpreassignauthseq table does not exist.
I;m not sure where I can get that sequence number generated.
I should say that I'm running Maximo 7.6.1 on MS SQL.
------------------------------
Bob Kraus
Missouri S&T
Original Message:
Sent: 05-23-2024 16:12
From: Martin Fabra
Subject: Unable to view/list/reassign a security group due to grpreassignauth record
Hi @Bob Kraus!
Whether the "maximum" or "sysadmin" users are added in the reassignment of the LEADS group has no relation to logging in or viewing said group.
Beyond this, to do what you need, you must know who can reassign you to this group. To do this, run this query:
select distinct userid from maximo.GRPREASSIGNAUTH where groupname = 'LEADS'
It will give you a list of USERIDs, which can be reassigned to you. Only they can.
Let them look for the LEADS security group and add you in the "Authorize Group Reassignment" option in the "More Actions" menu.
If they can't, run this insert per database that adds you:
insert into maximo.GRPREASSIGNAUTH (grpreassignauthid, userid, groupname) values (maximo.GRPREASSIGNAUTHSEQ.nextval, 'YOUR-USERID','LEADS')
replace YOUR-USERID with your user ID.
Regards!
------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
Original Message:
Sent: 05-23-2024 12:20
From: Bob Kraus
Subject: Unable to view/list/reassign a security group due to grpreassignauth record
Hi,
I have a group (LEADS) that has authorization assigned to users maximo and sysadm, neither of which I can log in as.
I would like to reassign this group for myself and user MAXADMIN.
How can I do that?
#MaximoApplicationSuite
#Security
------------------------------
Bob Kraus
Missouri S&T
------------------------------