This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: rem C:\oracle\ora92\bin rem you can find your spool file on Windows systems by searching for you file name rem for example *homework1a*.* rem use an editor and combine your sql file and the spool file rem and you have everything you need SQL> show user; USER is "MICHAEL" SQL> drop user ABLE; User dropped. SQL> create user ABLE identified by a; User created. SQL> grant select on student to able; Grant succeeded. SQL> grant create session to able; Grant succeeded. SQL> /* Connect to User account able */ SQL> connect able/a Connected. SQL> show user; USER is "ABLE" SQL> select count(name) from michael.student; COUNT(NAME) ----------- 5 SQL> select count(name) from michael.faculty; select count(name) from michael.faculty * ERROR at line 1: ORA-00942: table or view does not exist SQL> spool off...
View Full Document
- Spring '09
- Yelena - TA