Creation of a public table in oracle 10g
781284Jun 24 2010 — edited Jun 24 2010Hey Guys,
I got stcuk while creating a public table which allow all users on the system to access and tried to implement the concept of ownership and previleges but got the following error:
ORA-02421: missing or invalid schema authorization identifier
The query which i used is:
create schema authorization public
create table students (
surname char(15) not null,
first_name char(15),
D_O_B date,
student_no integer not null unique,
dept_no integer,
year decimal(2)
);
Could anyone please get me the resolution of this prolem.
Thank You!