Home > Data Miner 4.0 > Oracle Data Mining Applicat... > Install Prerequisites and O... > Installation Strategy > Multiple Data Miner Users > 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 ALTER ON MINING MODEL privilege allows you to change the mining model name or the associated cost matrix using the appropriate DBMS_DATA_MINING procedure. For example, you need the ALTER privilege to rename a cluster or change a comment about the model.
The SELECT ON MINING MODEL privilege allows you to view or score using the model using the appropriate DBMS_DATA_MINING procedure.
To view a model, use the DBMS_DATA_MINING.GET_MODEL_DETAILS_* procedures.
To score a model, use the Data Mining family of SQL functions or the DBMS_DATA_MINING.APPLY procedure.
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.