You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?
A.
Create a database user with connect, resource, and object privileges
B.
Create a database user with the default privileges
C.
Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL
D.
Create an IDCS user, create a database user with connect, resource, and object privileges
Enabling a new business analyst to use SQL Developer Web with Autonomous Database requires specific steps. The correct answer is:
Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL (C):
Create a database user:As the ADMIN user, create a new database user (e.g., ANALYST1) with CONNECT (to log in), RESOURCE (to create objects), and object-specific privileges (e.g., SELECT on target tables). Example: CREATE USER ANALYST1 IDENTIFIED BY "password"; GRANT CONNECT, RESOURCE TO ANALYST1; GRANT SELECT ON HR.EMPLOYEES TO ANALYST1;. This ensures the analyst can access and query tables.
Enable the schema for SQL Developer Web:Use the ORDS_ADMIN.ENABLE_SCHEMA procedure to activate the schema for web access. Example: EXEC ORDS_ADMIN.ENABLE_SCHEMA(p_schema => 'ANALYST1');. This step integrates the user with Oracle REST Data Services (ORDS), which powers SQL Developer Web in ADB.
Provide the user-specific URL:After enabling the schema, generate and share the SQL Developer Web URL, which includes the user’s credentials (e.g., https:// <adb-host>/ords/analyst1/_sdw). The analyst logs in with their database username and password, accessing a browser-based SQL interface to explore tables.
The incorrect options are:
Create a database user with connect, resource, and object privileges (A):This alone isn’t enough; without enabling the schema for SQL Developer Web, the user can’t access it via the web interface.
Create a database user with the default privileges (B):Default privileges (e.g., just CONNECT) are insufficient for table access or web use; specific grants and ORDS setup are needed.
Create an IDCS user, create a database user with connect, resource, and object privileges (D):Oracle Identity Cloud Service (IDCS) integration is optional and not required for basic SQL Developer Web access in ADB. It’s overkill unless SSO is mandated, which isn’t specified here.
This multi-step process ensures secure, web-based access tailored to the analyst’s needs.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit