Oracle 10g: Creating a new user/database?

Question

What is the syntax for creating a new user who will be able to create tables, drop tables, add/update data on the tables and perform queries? Also I noticed that when I use the select * from all_tables command I get a whole lot of information. Do I need to create a new database for the new user so I can see just the tables the new user has created when I use the above command? How do I do this? Can I then integrate this using Visual Basic 6?

Answer 1

create user newguy identified by newpass default tablespace tablespace_name temporary tablespace temp;
grant connect,resource to newguy;

All_tables is a view of all the tables that you can SEE, and includes many system tables.

The view user_tables will show only the tables owned by the logged-in user.

No - you definitely do not need a new database. Each user account has it's own objects that will be separate from the objects of other users. A set of objects under a username is called a schema. You could run several different applications from the same database by putting their tables in under different usernames.

Answer 2

Create Database In Oracle 10g

Answer 3

In layman's term we are able to assert that "device" is a database (yet in oracle its observed as schema) the least confusing thank you to create a a schema is to apply the oracle em console and create someone. once you create someone, you're certainly becoming a schema. then you particularly can later upload tables to it.