Creating a User in Oracle Autonomous Database
Before installing Oracle Autonomous Database using the PTC Solution Installer (PSI), create a user with a SQL client tool and use its credentials during installation. For more information, see Entering Your Database Information.
Follow these steps to create a user:
1. Connect to the Oracle Autonomous Database using a SQL client tool (for example, sqlplus) with administrator user credentials.
2. Create a user using the following command:
SQL> create user &&user identified by &&password;
Enter value for user: <user>
Enter value for password: <password>
old 1: create user &&user identified by &&password
new 1: create user <user> by <password>
Enter value for user: <user>
Enter value for password: <password>
old 1: create user &&user identified by &&password
new 1: create user <user> by <password>
 |
Provide the username and password when prompted.
|
3. Grant the necessary privileges to the user using the following commands:
SQL> grant connect, resource to &&user;
SQL> grant create sequence, create view, unlimited tablespace to &&user;
SQL> undefine user;
SQL> grant create sequence, create view, unlimited tablespace to &&user;
SQL> undefine user;