1. You have been hired as the new DBA for Henry Books and are installing a new s

Question

1. You have been hired as the new DBA for Henry Books and are installing a new security system.

2. Everyone is now required to sign in. You will be assigning ids (they will create their own passwords).

3. Ray Henry the owner may do anything to the database.

4. There are 2 salesclerks who may only read the tables. Assign their ids and create their privileges.

5. Any customer may access book information. Create the privilege which allows this.

6. Create the queries which will satisfy the above (#4, #5)

7. SUBSTR is a function which allows you to subdivide a character or string field. Its form is SUBSTR (fieldname,beginning position,length of data) such as
SUBSTR(custname,1,5) will get the first 5 characters of customer name.

8. USER is a register in the DBMS which contains the id of the user who is signed on at this time.

Explanation / Answer

6.

Create users, roles and grant privileges to satisfy the conditions

CREATE USER customer IDENTIFIED BY Id;

CREATE USER sales_clerks IDENTIFIED BY Id;

CREATE ROLE scheme_rw_role;

CREATE ROLE scheme_r_role;

GRANT schema_rw_role TO customer

GRANT schema_r_role TO sales_clerks

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.