Creating Users




Si te krijojme nje user


create user student
identified by student
default tablespace users
temporary tablespace temp
profile default
account unlock;


grant connect to student;
grant create cluster to student;
grant create indextype to student;
grant create operator to student;
grant create procedure to student;
grant create sequence to student;
grant create session to student;
grant create table to student;
grant create trigger to student;
grant create type to student;
grant unlimited tablespace to student;


conn scott/student

create table c_test(a number);