Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Installation Guide for Microsoft Windows > Installing the Siebel Database on the RDBMS > Creating Table Owner and Administrator Accounts > Running the grantusr.sql Script on an Oracle DatabaseBefore you install the Siebel database, your DBA must review, modify, and execute the grantusr.sql script. The administrator executes grantusr.sql against the database instance to create the Siebel table owner account, the Siebel administrator account (default: SADMIN), the LDAPUSER account, and the role SSE_ROLE and to grant them appropriate privileges. The script also creates the default tablespace. The grantusr.sql script is located in the After executing grantusr.sql, the DBA must manually create all of the additional tablespaces (for data or indexes) that you require in your Siebel database. To do this, use commands similar to the existing ALTER USER command defined in grantusr.sql for creating the default tablespace. Use commands similar to the following: ALTER USER
The grantusr.sql script performs the following functions:
Passwords are prompted for by the script, rather than defined within the script. The length and allowable characters for the user name and password depend on the rules of your underlying RDBMS platform. For more information, see Oracle Database documentation. This topic is part of Creating Table Owner and Administrator Accounts. To run the grantusr.sql script on an Oracle Database
|
![]() ![]() |
Siebel Installation Guide for Microsoft Windows | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |