4 1 1 Add a new ORACLE User Id

Install LANSA on Linux

4.1.1 Add a new ORACLE User Id

If you want each user to be distinguishable by their ORACLE user id, you will need to create an ORACLE user id for each user. If not, you should create at least one ORACLE user id to distinguish a user from the owner of the tables. This will allow you to stop users from modifying or dropping required tables.

LANSA requires ORACLE user ids and passwords of no more than 10 characters.

When you add a new user to access the LANSA application, grant the role LANSA_USER to the user. This role has been granted SELECT, INSERT, UPDATE, and DELETE privileges on every table and view that LANSA creates. It also has the CREATE SESSION privilege.