Creating user, grants and tables in ADB

This topic describes the systematic instructions to creating user, grants and tables in ADB.

  1. 1. Login to OCI Using your credentials. Switch to the region you have access to 23ai Autonomous Database.
  2. From the Menu, click Oracle Database, then click Autonomous Database.
  3. Click Database Actions and then click SQL.

    Figure 5-7 Autonomous Database


    Description of Figure 5-7 follows
    Description of "Figure 5-7 Autonomous Database"

    The SQL editor screen is displayed.

  4. Select the user.

    Figure 5-8 SQL editor


    Description of Figure 5-8 follows
    Description of "Figure 5-8 SQL editor"

  5. Create user and grant the following privileges.
    1. CREATE USER <USER_NAME> IDENTIFIED BY <USER_PASSWORD> DEFAULT TABLESPACE <TABLESPACE>;
    2. GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, UNLIMITED TABLESPACE TO <USER_NAME>;
  6. Switch to the above created user.
  7. Next, execute the following SQL commands for each product in the list given below:
    1. OBCL
    2. OBRL
    3. OBCLPM
    4. OBO
    5. OBTF
    6. OBSCF
    7. OBTFM
    CREATE TABLE CMC_TB_AIF_EMBEDDING_<PRODUCT> 
( BRANCH_CODE VARCHAR2(6 CHAR) NOT NULL ,
 EMBED_SCOPE VARCHAR2(10 CHAR) NOT NULL ,
 USER_ID VARCHAR2(320 CHAR) NOT NULL , 
USE_CASE VARCHAR2(100 BYTE) NOT NULL ,
 REFERENCE_ID VARCHAR2(100 CHAR) , 
UPLOAD_DATE DATE NOT NULL ,
 CHAT_ID VARCHAR2(36 CHAR) ,
 ID VARCHAR2(36 CHAR) NOT NULL ,
 PROVIDER VARCHAR2(100 CHAR) ,
 EMBED_MODEL_NAME VARCHAR2(100 CHAR) ,
 DOC_CATEGORY	VARCHAR2(100 CHAR) ,
 DOC_NAME VARCHAR2(255 BYTE) ,
 DOC_ID VARCHAR2(22 BYTE), 
PAGE_NO NUMBER(4, 0) , 
CHUNK_SEQ NUMBER(15, 0) , 
CHUNK_RAW VARCHAR2(6000 CHAR) ,
 VECTOR_EMBEDDINGS VECTOR , 
CONSTRAINT PK_EMBEDDING_<PRODUCT> PRIMARY KEY (USE_CASE,REFERENCE_ID,DOC_NAME,DOC_ID,PAGE_NO,CHUNK_SEQ) );


CREATE INDEX IDX_CMC_TB_AIF_EMBEDDING_<PRODUCT>

ON CMC_TB_AIF_EMBEDDING_<PRODUCT>  (USE_CASE, REFERENCE_ID, DOC_CATEGORY, DOC_ID);