Database users are granted access to read, insert, update,
and delete specific objects that define a set of fields and business
rules. These objects can also update one or more database tables.
In the Users application, you use the Database Access action
to create database users. If you implement databases that need operating
system IDs, you must create the operating system ID.
The default database username is maximo.
The following commands detail the standard authorizations that
are required:
- Create user dbusername identified by the system
- Alter user dbusername default table space quota
as unlimited
- Alter user dbusername temporary table space
temp
- Grant create trigger to dbusername
- Grant create session to dbusername
- Grant create sequence to dbusername
- Grant create synonym to dbusername
- Grant create table to dbusername
- Grant create view to dbusername
- Grant create procedure to dbusername
- Grant alter session to dbusername
- Grant execute on ctxsys.ctx_ddl to dbusername
To allow database access to users, the following commands detail
the additional grants that are required to create database users:
- Grant create user to dbusername
- Grant drop user to dbusername
- Grant create session to dbusername with admin
option
- Grant alter user to dbusername