--Developing Oracle Applications with Developer/2000
--@C:\DEV2000\SQL\GRANTS.SQL

spool C:\DEV2000\SQL\GRANTS.TXT

Prompt Developing Oracle Applications with Developer/2000
connect scott/tiger
Prompt Granting Select on Tables to Public as...

select substr (user,1,20) User_Id,
sysdate Sys_Date,
substr (to_char(sysdate, 'HH:MIAM'),1,10) Sys_Time from dual;

grant select on contact			to public;
grant select on customer		to public;
grant select on dept			to public;
grant select on emp			to public;
grant select on emp_audit		to public;
grant select on rpt_audit		to public;
grant select on state			to public;

Prompt Done Granting Select on Tables to Public.

spool off;
