Create a User Account Using SQL Developer

Follow these steps to create a user account:

  1. Start SQL Developer and open the Administrative connection defined in Create an Administrative Database Connection; scroll down to Other Users.

  2. Right-click Other Users and select Create User.

  3. Specify username, password, default tablespace, and temporary tablespace.

  4. Click the Roles tab and click the check box to grant Connect.

  5. Click the Quotas tab and click the check box to set tablespace to unlimited (for the default tablespace).

  6. Click Apply to create the account.

  7. Now Connections for Data Mining. You must create a database connection for the account and then add the connection to the Data Miner navigator.

If the repository is not yet installed, go directly to Install the Data Miner Repository Using the GUI. The installation process grants the privileges to the user. If you Install the Repository Using Scripts, you must grant privileges explicitly.

If the repository is already installed, you must grant privileges explicitly if you use scripts. You can also grant rights using the GUI if you open a connection to the account in the Data Miner Navigator.