To create the database user, complete the following steps.
-
The user needs a login, in the example
'IDENTIFIED BY PASSWORD'
If you want to use a different authentication type, see the
Oracle documentation for more information.
- The user needs an
unlimited quota on the default tablespace.
-
Create a user with password authentication according to the
following example.
Note: The user name must be written in capital letters.
CREATE USER BIC
IDENTIFIED BY <password>
DEFAULT TABLESPACE BIC
TEMPORARY TABLESPACE T_BIC
QUOTA UNLIMITED ON BIC;
-
Grant the user the permissions required to create database objects
according to the following example.
GRANT
CONNECT,
CREATE SESSION,
CREATE TABLE,
CREATE TYPE,
CREATE INDEXTYPE,
CREATE PROCEDURE,
CREATE SEQUENCE,
CREATE SYNONYM,
CREATE PUBLIC SYNONYM,
CREATE TRIGGER TO BIC;