CS540_C_HW9_14223_NISHANT_PATEL.docx -...

CS540_C_HW9_14223_NISHANT_PATEL
Course ID :- CS540
Student ID :- 14223
Section ID :- C
Name :- Nishant Patel
Homework :-9

1: Briefly describe what is Schema?
A schema is a named collection of objects such as tables, views, clusters, procedures, and packages
associated with a particular user.
A user is created, and a corresponding schema with the same name is created for that user.
A user can be associated only with the schema of the same name, and therefore username and schema
are often used interchangeably.
2: Briefly describe how user must be use OS authentication to access DBMS?
Use the IDENTIFIED EXTERNALLY clause of the CREATE USER command to specify that a user must be
authenticated by the operating system.
This option is generally useful when the user logs on directly to the machine where the Oracle server is
running.
3: Briefly describe what are two types of database user privileges?
Two types of Oracle user privileges:
- System: Enables user to perform particular actions in the database.