Granting Access

Tables and views can be granted privileges using SQL Developer. One way to do this is to find the table or view in the SQL Developer Connections navigator, right-click, and select Privileges.

To authorize operations on a mining model, grant these mining model privileges. (These privileges are not required for models within the user's own schema.)

The following example grants SELECT for the model CLAS_GLM_1_10 built in the DMUSER2 account to the DMUSER account:

GRANT SELECT ON MINING MODEL DMUSER2.CLAS_GLM_1_10 TO DMUSER;

After this command executes, DMUSER will be able to view or score CLAS_GLM_1_10. If DMUSER needs to rename the model, grant ALTER MINING MODEL:

GRANT ALTER ON MINING MODEL DMUSER2.CLAS_GLM_1_10 TO DMUSER;

For information on the GRANT statement, see the Oracle Database SQL Language Reference.