Access to a oracle Database

Question

I have created a database in Oracle. Say "TEMP" is the name of the database created. I have created a user DWH. Now I would like to grant access to TEMP for the user DWH. How shall i do?

Answer 1

. When you say you have created a user DWH do you mean at operating system level or database level ?If you have created a database user

Anyway the command for creating a user in database is

create user DWH identified by password;

Now if you want to be able to connect to database and create a table you need the following

grant create session to DWH;
    alter user DWH default tablespace users quota 100m on users;
    grant create table to DWH;

You can grant other permissions also.You can also group permissions into a role and grant the role.