For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? (Choose the best answer.)
Click on the arrows to vote for the correct answer
A. B. C. D.B.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEAThe correct answer is C. SQLDEV_ADMIN.GRANT_SCHEMA.
SQL Developer Web is a browser-based tool for working with the Oracle Autonomous Database Cloud Service. It provides an easy-to-use interface for managing database objects, writing and executing SQL queries, and performing various administrative tasks.
To allow a user who is not a service administrator to use SQL Developer Web, you need to grant them the necessary privileges. The SQLDEV_ADMIN package provides the necessary procedures and functions to manage SQL Developer Web users and their privileges.
The GRANT_SCHEMA procedure in the SQLDEV_ADMIN package is used to grant a user access to a specific database schema. This procedure takes three parameters: the name of the user or role to be granted access, the name of the schema to be accessed, and the privilege level to be granted (such as READ, WRITE, or EXECUTE).
For example, to grant the user "jdoe" read access to the "hr" schema, you could run the following SQL statement:
javascriptBEGIN SQLDEV_ADMIN.GRANT_SCHEMA( grantee_name => 'jdoe', schema_name => 'hr', privilege => 'READ'); END; Note that this procedure requires the user running it to have the SQLDEV_ADMIN role. So, you need to ensure that the user executing this statement has the necessary privileges.
In summary, to allow a user who is not a service administrator to use SQL Developer Web, you need to grant them access to the appropriate schema using the SQLDEV_ADMIN.GRANT_SCHEMA procedure.