Tridion Docs ships with an SQL script that creates a Tridion Docs administrator user. After running the script, you can use this new user when you run a PowerShell script to create a database for Content Manager security. The privileges and roles created for this user are the minimum requirements for database installation.
Procedure
- On your Tridion Docs installation media, go to the folder Database\Shared\Scripts\Oracle\Create\.
- Run the SQL script TridionSYSUser.sql (say, from SQL*Plus).
- When prompted, give the following information:
| Username | The name of the Tridion Docs administrator user that can create the database. RWS proposes the user name TRIDION_DOCS_SYS.
Note: You cannot use a user that must connect as SYSOPER or SYSDBA with the PowerShell script.
|
| Password | The password of this user |
| Default tablespace | The default tablespace for objects the user creates |
| Temporary tablespace | The tablespace for the user's temporary segments |
What to do next
Once this user has been created, you can proceed to create your databases for Content Manager security.