Security. Understanding Database Users in MAXIMO

When you create or update a database user ID, grant the user access to the system’s tables. To grant access to the system’s tables, click the Object Name icon and select a table object. Also, specify the level of ccess, either Read, Insert, Update, or Delete.

The system only creates database user IDs when you select this option. The system does not create operating system IDs for databases that require an operating system ID on the database server. If you implement databases with this requirement, create the operating system ID.

Access to tables is not assumed and mustbe granted. Rights are not defaulted out-of-the-box.

At the time of installation, if database users are created, some additional grants that the system uses must be supplied to the database user. The following commands detail the standard grants that the system requires:

• Create user maximo identified by the system
• Alter user maximo default tablespace maximo quota unlimited on maximo
• Alter user maximo temporary tablespace temp
• Grant create trigger to maximo
• Grant create session to maximo
• Grant create sequence to maximo
• Grant create synonym to maximo
• Grant create table to maximo
• Grant create view to maximo
• Grant create procedure to maximo
• Grant alter session to maximo
• Grant execute on ctxsys.ctx_ddl to maximo

In the Users application, to allow the systemto give database access to users, the following commands detail the additional grants that are required for the system to create database users:

• Grant create user to MAXIMO
• Grant drop user to MAXIMO
• Grant create session to MAXIMO with ADMIN OPTION
• Grant alter user to MAXIMO