Question

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.

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) );