To create a security database, you need the 'Create security database' permission
To create a security database, you need the 'Create security database' permission
Security databases must only be created and registered from the System Management module. Do not attempt to create a security database outside of MACRO (from within SQL Server or Oracle) as invalid references are likely to be created, leading to data corruption.
Select Database > Security Database... The Security Database window is displayed.
Click Create.
Select Oracle or SQL Server.
Choose whether your security database will be Server or Site. If 'site', type the site name into the text box.
Enter the user and database details. If creating a SQL Server database, you must ensure that the Server and Database fields are filled in, otherwise the new MACRO tables will be created in the default SQL Server Master table.
To test whether the connection works, click Test.
If the connection is successful, click OK to set up the new security database.
To set the security database for the next session, you need the 'Set security database' permission
Select Database > Security Database... The Security Database window is displayed.
Click Next Session.
Follow steps 3 - 7 above.
Log out of System Management. When you log back in to any module, you will be connected to the security database you just specified.