grants

Download Grants

If you can't read please download the document

Upload: kesava

Post on 04-Jan-2016

213 views

Category:

Documents


1 download

DESCRIPTION

Grants

TRANSCRIPT

SPOOL C:\SPOOL\DBMS_GRANT.SPLGRANT EXECUTE ON DBMS_LOCK TO '&User';GRANT EXECUTE ON DBMS_PIPE TO '&User';GRANT EXECUTE ON DBMS_ALERT TO '&User';GRANT EXECUTE ON DBMS_DEFER TO '&User';GRANT EXECUTE ON DBMS_DEFER_SYS TO '&User';GRANT EXECUTE ON DBMS_DEFER_QUERY TO '&User';GRANT SELECT ON V_$SESSION TO '&User';GRANT SELECT ON V_$PARAMETER TO '&User';GRANT SELECT ON V_$TIMER TO '&User';GRANT SELECT ON V_$lock TO '&User';GRANT SELECT ON v_$rollname TO '&User';GRANT SELECT ON V_$DATABASE TO '&User';GRANT SELECT ON v_$instance TO '&User';grant select on dba_jobs_running to '&User';grant select on dba_jobs to '&User';grant select on dba_objects to '&User';grant select on dba_free_space to '&User';grant select on v_$process to '&User';grant select on gv_$session to '&User';grant select on gv_$instance to '&User';grant select on v_$mystat to '&User';SPOOL OFF