Hey All,
I just want to double check I have not missed a change of DB Privileges for user STUDENT.
All questions so far have been done up till now using user STUDENT.
Currently STUDENT does not have rights to create or alter views.
SQL> select * from session_privs;
PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
10 rows selected.
I have gone through all the tut letters and the Manual and cannot find a change in privileges.
Have I missed it or am I correct in saying STUDENT should not have CREATE VIEW or CREATE ANY VIEW at this point.
Cheers
Darren