Creating the Central Designer database user
- On the database server computer, extract the folder CreateCentralDesignerSchema from the product ZIP file.
Note: You must use the ZIP file for the product version being installed, or the Central Designer database user will not be given the appropriate grants.
- From the CreateCentralDesignerSchema folder, run the following command:
sqlplus <Database Administrator user name>/<Database Administrator password>@<Database> @_task.sql <Central Designer database user name> <Central Designer database user password> <Central Designer tablespace>
In the previous command:
- Database Administrator user name / password—Credentials of the database administrator used to create the Central Designer database user.
- Database—Alias from the TNSnames.ora file.
- Central Designer database user name / password—Credentials of the Central Designer database user account you are creating.
- Central Designer tablespace—Default value: DESIGNER.
When you run the Central Designer installation, you must enter the database parameters set up during this procedure.