Need to create a schema in oracle and can someone give me syntax
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
The user who would execute the above command should have necessary rights (CREATE USER privilege)
Just creating a new user (or schema) will be useless without privileges. Because you cannot even login without CREATE SESSION granted!
Check the below link for different type of privileges you could grant to a user.
http://ss64.com/ora/grant_
It would be simpler to create a role, assign privileges to the role and grant the role for any user.
CREATE SCHEMA AUTHORIZATION user_name
Note:
The schema name must be an existing Oracle username.
More info:
http://ss64.com/ora/schema
CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> GRANT CONNECT TO <USERNAME>
as stated earlier you will need to have the system privs to create users and make the grants
GRANT CONNECT is assumed to be your role that has the CREATE SESSION system privilege so that the user can actually login and get onto the database, you will also need to add grants for the user to be abel to select from tables, create tables, etc.
I don't understand.. You need to login to the database (eurob in your case) and issue the CREATE USER statement to create the user. After that grant necessay privileges. If you have a dump file (.dmp) then make use of imp or impdb to import it.
Out of the above steps, for which and all do you need syntax? CREATE USER and grant privilege syntax are already provided.
Taaz
a schema and a suers are exactly the same thing
if you create a schema then you have created a user and if you create a user you have created a schema;
this command
CREATE USER taaz
IDENTIFIED BY taaz
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE <your temp file>
PROFILE DEFAULT
ACCOUNT UNLOCK;
will create a user /schema called tazz we will refer to it as a user if we are talking about privilage issues who is the owner like fro tables in dba_tables;or dba_objects.
and we will refer to it as a schema if we are talking about the logical container that hold the tables,indexes ,views the user tazz has .
Business Accounts
Answer for Membership
by: ravindran_eeePosted on 2009-08-25 at 04:18:56ID: 25176279
CREATE USER <username> IDENTIFIED BY <password>