Documentation Center

Creating an SQL Tridion Docs administrator user for Oracle

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

  1. On your Tridion Docs installation media, go to the folder Database\Shared\Scripts\Oracle\Create\.
  2. Run the SQL script TridionSYSUser.sql (say, from SQL*Plus).
  3. When prompted, give the following information:
    UsernameThe name of the Tridion Docs administrator user that can create the database. RWS proposes the user name TRIDION_DOCS_SYS.
    PasswordThe password of this user
    Default tablespaceThe default tablespace for objects the user creates
    Temporary tablespaceThe 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.