I've successfully installed Oracle 11g R2 database Enterprise Edition on Oracle Linux 6.2 last week. I've been reading the manuals and this
. I'm confused about two things:
1. When I create a new user as shown below in SQL*Plus, I'm not sure what to assign / grant for each user so they can login and begin using the system...
CREATE USER carlos IDENTIFIED BY some_pass
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
So the above creates the user 'carlos' fine however I'm looking for at minimum what Oracle 11g requires each user to have to start using the system. I was told I had to grant 'connect' & some other permissions as well.
2. Understanding how databases are created / owned:
The last part I'm confused about is maybe due to my misunderstanding of the word 'database' and how Oracle manages work areas. In MySQL & PostgreSQL, you create a database with the 'CREATE DATABASE' command. Then you assign the database an owner and that user then connects to the newly created database. In Oracle, I'm using an 11g system with a SID of test. I'm not 100% clear on if the SID name is a 'database' name or just a system I.D. but I'm guessing since Oracle can only have one unique SID, it's just an identifier and under this system, I can create many different schemas which are treated like databases in PostgreSQL, no? After I create the role / user above and give him whatever grants / permissions one needs to interact w/ 11g, how can I create a database for 'carlos' to start working? I'm trying to create a database for carlos called 'fcs' and I need carlos to be able to connect to this 'fcs' database or schema and create relational-oriented tables for my project.
Thanks for any clarification!