Basic HTML version of Foils prepared 7 October 97

Foil 43 What are Schemes?

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou
1 Schemes are used to define scope of different data objects to enforce data secuity and naming issues in a DBMS.
2 A Scheme in a DB is a logical hierarchy of data storage structures.
3 Major scheme objects are: users, tablespaces, tables, views, index, cluster, synonyms, columns.
4 Access to Different Schemes require different roles and privileges for different users.
in Table To:

© on Mon Oct 13 1997