4.1 Access Oracle Big Data SQL

The basics for accessing a cluster within Oracle Big Data SQL are explained here.

At a minimum, you must do the following for each user who needs access to Oracle Big Data SQL:

  • Grant the BDSQL_USER role.
  • Grant read privileges on the Oracle Big Data SQL configuration directory object. For example, to grant access to user1:
    SQL> grant BDSQL_USER to user1;
    SQL> grant read on directory ORACLE_BIGDATA_CONFIG to user1;