1 / 9

Tuesday, November 1, 2000 “Transaction processing”

OLTP. Lecture No. 18. Tuesday, November 1, 2000 “Transaction processing”. OLTP. CONTENTS Concurrency control Transactions and schedules Serializability Anomalies due to concurrency Locking/ Time stamping. Concurrency. User SYTEM and SYS users. Authority. Role Connect

everly
Download Presentation

Tuesday, November 1, 2000 “Transaction processing”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OLTP Lecture No. 18 Tuesday, November 1, 2000 “Transaction processing”

  2. OLTP CONTENTS • Concurrency control • Transactions and schedules • Serializability • Anomalies due to concurrency • Locking/ Time stamping

  3. Concurrency User • SYTEM and SYS users

  4. Authority Role • Connect (select, insert, update, delete, create tables) • Resource (Create tables, SP, triggers, indexes and clusters) • DBA (All system privileges, grant privileges, unlimited space quota )

  5. Authority Grant • Granting system privileges grant role to user; grant CONNECT, RESOURCE to ARUL; • Granting object privileges grant priv on object to user; grant select on customerTable to ARUL;

  6. Authority Guidelines 1. You cannot grant a privilege that you do not have 2. You cannot grant privileges on objects that you do not own. 3. You cannot grant privileges on objects for which you don’t have the authority to grant. 4. You cannot access objects for which you have not been granted privileges.

  7. Authority Creating roles 1. Create role Create role CLERK; 2. Grant privileges to role grant create session to clerk; 3. Grant a role to users; grant clerk to ARUL; Teaser: Why should we create such roles

  8. Dictionary Data dictionary • Stores information that is used to manage the objects in the database. • USER, ALL and DBA prefixes. • DICTIONARY table

  9. Dictionary Examples • USER_OBJECTS • USER_TABLES • USER_VIEWS • USER_CONSTRAINTS • USER_INDEXES • USER_SOURCE • USER_USERS

More Related