Database users
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