Safran User

Safran User

This API will use the Safran Users defined in the Safran Software Solution, such as Safran Project. Therefore, any users related to the Safran data and used with this API must already exist, be enabled and be present in the database.

In addition to the Safran Users, a user must be defined and configured for the connection between the API and the database. This user could be the same as any of the Safran Users. This connection user must be able to retrieve specific details from the database, such as:

• On the Microsoft SQL server, perform a select command on the table "master.sys.server_principals"
• On the Oracle server, perform a select command on the table "dba_users"

Please refer to DBMS vendor documentation on permission settings on these tables.

Adding a new Safran Project user.

The "Safran System Administration tool" documentation will list the necessary steps to create a Safran Project user. Please refer to that documentation for further information.

Adding a Microsoft SQL server user.

Before adding a Safran User, some work must be performed on the Microsoft SQL server database, such as creating a login and database user.

• A Login is an account on the SQL Server - someone who can log in to the server and who has a password.
• A User is a Login with access to a specific database.

Please refer to the Microsoft MS SQL server documentation for further information.

Adding an Oracle server user.

Before adding a Safran User, some work must be performed on the Oracle database, such as creating a database user.

Please refer to the Oracle server documentation for further information.