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

spool C:\DEV2000\SQL\REVOKE.TXT

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

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

revoke select on contact		from public;
revoke select on customer		from public;
revoke select on dept			from public;
revoke select on emp			from public;
revoke select on emp_audit		from public;
revoke select on rpt_audit		from public;
revoke select on state			from public;

Prompt Done Revoking Select on Tables from Public.

spool off;
