Question

topic: oracle sql I have a database 'guitar'. I want to add a user to that...

topic: oracle sql

I have a database 'guitar'.

I want to add a user to that database.

Please get me started at least with overview / tutorial.

Homework Answers

Answer #1

You should have specified which user, i mean who will use this database(administrator) or you want to store user's in your database in your table but i will give you both

How to Create a User and Grant Permissions in Oracle

  1. CREATE USER books_admin IDENTIFIED BY MyPassword;
  2. GRANT CONNECT TO books_admin;
  3. GRANT CONNECT, RESOURCE, DBA TO books_admin;
  4. GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;
  5. GRANT UNLIMITED TABLESPACE TO books_admin;
  6. GRANT SELECT, INSERT, UPDATE, DELETE ON schema. books TO books_admin;

You want to make table of users

CREATE TABLE guitar.persons( person_id NUMBER GENERATED BY DEFAULT AS IDENTITY, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL, PRIMARY KEY(person_id) );

 

 
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using the Company database in Oracle, construct SQL queries for the following (note: I will make...
Using the Company database in Oracle, construct SQL queries for the following (note: I will make the files to create and populate the Company database available on Isadore shortly): List the last name and address of managers who have a dependent with the same first name as themselves. Retrieve the names of all employees who are directly supervised by ‘Franklin Wong’. Retrieve the names of employees in the Research department who work more than 20 hours per week on the...
PS8 JULY 1. Log on to your Oracle ApEx account. Navigate to SQL Workshop à SQL...
PS8 JULY 1. Log on to your Oracle ApEx account. Navigate to SQL Workshop à SQL Scripts Create a SQL script called update_demo_orders that contains these update statements: update demo_orders set order_total = 200 where customer_id = 1; update demo_orders set order_total = 15 where customer_id = 2; update demo_orders set order_total = 12 where customer_id = 3; update demo_orders set order_total = 22 where customer_id = 4; update demo_orders set order_total = 32 where customer_id = 5; update demo_orders...
Hi , please i just want an explanation in this topic just provide any clear small...
Hi , please i just want an explanation in this topic just provide any clear small example to illustrate the topic to me : 1- deletion by copying in binary search tree. 2- deletion by merging in binary search tree. thank you so much tomorrow i have an exam and i hope you make it clear to me, thanks again
A Complete Overview Of Game Theory ACTUALLY I HAVE TO PRESENT THIS TOPIC IN THE CLASS...
A Complete Overview Of Game Theory ACTUALLY I HAVE TO PRESENT THIS TOPIC IN THE CLASS FOR 3-4 MINUTES SO PLEASE MAKE A HALF PAGE REPORT OF GAME THEORY AND COVER ITS MAIN POINTS.
I have to write an 4 pg analysis paper on any topic dealing with public and...
I have to write an 4 pg analysis paper on any topic dealing with public and private goods and its for my microecon class. Can you please write me an outline of an essay and points I should hit.
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects....
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch08_ConstructCo database are shown in Figure P8.1. Use this database to answer the following problems. Database Schema The schema for the Ch08_ConstructCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own...
i have 1052 data set i want to divide the data for validation into two groups...
i have 1052 data set i want to divide the data for validation into two groups 30% and 70 % in SPSS i asked the question before twice and you told me that to copy the 70 % then the remaining is 30 % i still can not do this because i have the 70 % from filter but i cant extract the remaining 30% ,what is the clear steps to divide into tow groups of data (the fast way...
I am finding the topic "Modelling with Functions" challenging. In particular, I have difficulties in translating...
I am finding the topic "Modelling with Functions" challenging. In particular, I have difficulties in translating a verbal model into an algebraic notation to translate a function. One example of the problems that gives me trouble is: A discount pass for a bridge costs $21 a month. The toll for the bridge is normally $2.50, but it is reduced to $1 for people how have purchased the discount pass. Express the total monthly cost to use the bridge with a...
Hi, I want you get a clear and short opinion about the question is below. Please...
Hi, I want you get a clear and short opinion about the question is below. Please try to give me clean opinion so I can understand the case and if you can provide me the explanation with a different example I will be happy about it. Thank you very much for the time that you will be spending on this question. Peace! When biofuels like ethanol started to be encouraged, many farmers expected high returns because of increased demand for...
I am a software engineer and not an astrophysicist but I want to know if anyone...
I am a software engineer and not an astrophysicist but I want to know if anyone is working on sorting out what exists outside the universe? So what about outside spacetime? what is there? or shall I assume there are infinite galaxies? and even that is not a satisfying answer. I know this question might get closed soon ... but guys please tell me what is there outside the space as we know it? since childhood I have wondered about...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT