Let the following organizational structure be planned for the application 'travel agency'. Only one SERVERDB shall be available.
First the SYSDBA creates two DBAs. The tables used in the examples shall be assigned to these DBAs at a later point in time.
The user 'travel10' shall be able to connect simultaneously and repeatedly to the database from different terminals. This is obtained by the specification 'NOT EXCLUSIVE'. The user 'travel20' shall not be allowed to do this.
CREATE USER travel10
PASSWORD t10
DBA NOT EXCLUSIVE
CREATE USER travel20
PASSWORD t20
DBA
If a distributed database is concerned, one could also think of another constellation. There are two SERVERNODEs, with one SERVERDB each, which form the distributed database.
The respective SYSDBAs create the users 'travel10' and 'travel20' on different SERVERNODEs.
