SPOOL PRIVS.LOG
REVOKE OLAP_DBA, DBA FROM CS_OLAP;
GRANT OLAP_USER TO SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWC_CHANN8VIEW to SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWG_STAND9VIEW to SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWP_PRODU10VIEW to SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWP_PROMO11VIEW to SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWSALE14VIEW to SCOTT;
grant select on CS_OLAP.CS_O_SHAW_SHAWT_CALEN12VIEW to SCOTT;
grant all on CS_OLAP.AW$SHAW to SCOTT;
SPOOL OFF
quit;