table to be created under sys when log-in as newuser
936666May 31 2013 — edited Jun 1 2013conncet sqlplus / as sysdba
CREATE USER user1 IDENTIFIED BY "user1";
grant create session to user1;
grant create table to user1;
conncet sqlplus
Enter user-name:user1
Enter password-user1
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
create Table sys.one (i number(5), j number(5));
ORA-01031: insufficient privileges
from the user1 i need to create a table which should be there when i log in as sqlplus / as sysdba and see one table under sys.
is it is possible or i need to grant some master privilege kind to create the table.