/*
 * Title  : acp_gra.sql
 * Author : EXADIME LLC
 * Created: 3-JUL-2017
 * Updated: 3-JUL-2017
 * Release: 1.0
 * Purpose: Auto Capacity Planner
 * History: N/A
 */

CREATE ROLE ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_DB_SGS_GB TO ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_TS_SGS_MB TO ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_US_SGS_MB TO ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_DBW_SGR_GB TO ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_TSW_SGR_MB TO ACP_READ_ROLE
/

GRANT SELECT ON V$ACP_USW_SGR_MB TO ACP_READ_ROLE
/
