Make a new user in SQL developer to create a new database -


i trying create new user , database when oracle sql developer says have insufficient permissions.

i have searched hours in google , found way create new user in hr database through sql command line. so, see new user in oracle sql developer wont let me create tables.

when try create table says "error - new table tabletest not found in database."

and if try create again says "name tabletest in use."...

any appreciated.

i think want create new user own tables. in case want create new scheme, not new database.

first, must create user user1 user user0 having privileges create users:

user0> create user user1 identified password; 

second, assign system privileges user:

user0> grant create table user1; 

third, log in user1 in sql developer , create table:

user1> create table tabletest (column1 varchar2(10)); 

then, can query table:

user1> select * tabletest; 

by last, if want query tabletest user0, must give privilege user1:

user1> grant select on tabletest user0; 

log in user0 , display query:

user0> select * user1.tabletest; 

regards


Comments