Grant all access to maxadmin at once in maximo

Its very painful to go to each security group and assign access to each permission for maximo.

i have been struggling with this for quite some time. 

Please run this query if you have oracle as backend for maximo, maximo installation automatically creates sequences by default and below statement will run fine for oracle users.

insert into applicationauth (app, optionname, groupname, applicationauthid) select app, optionname, 'MAXADMIN', applicationauthseq.nextval from sigoption s where optionname != 'NOPORTLET' and not exists (select * from applicationauth a where a.app = s.app and a.optionname = s.optionname and a.groupname ='MAXADMIN');

in case you are using sql server , please follow below method. 

 The applicationauthseq will only be available in oracle , for sql server you need to create a sequence on your own. 

 insert into applicationauth (app, optionname, groupname, applicationauthid) select app, optionname, 'MAXADMIN', NEXT VALUE FOR dbo.appauthseq from sigoption s where optionname != 'NOPORTLET' and not exists (select * from applicationauth a where a.app = s.app and a.optionname = s.optionname and a.groupname ='MAXADMIN');

Another important step to make it work.

update the maxsequence table with new maxreserve values.

Do a

select max(applicationauthid)+1 from applicationauth table and find out the max value for the applicationauth id


for me it was 

SELECT max(applicationauthid)+1
  FROM [dbo].[applicationauth] 
GO

Result 

73535



This needs to be inserted in maxsequence table, else you wont be able to insert any new signature options or duplicate applications.


Update the maxsequence table, mine looks like this.

APPLICATIONAUTH APPLICATIONAUTHID 73535 NULL NULL APPLICATIONAUTHSEQ 342 <Binary data>

That’s it , restart and re login, all the access will be available to maxadmin.

Error

BMXAA4211E - Database error number 2601 has occurred when operating on XXXX will appear if you dont follow last step mentioned above, maximo running on sql server need to update sequences.