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

CS540_C_HW9_14223_NISHANT_PATEL.docx -...

This preview shows page 1 - 3 out of 4 pages.

CS540_C_HW9_14223_NISHANT_PATEL Course ID :- CS540 Student ID :- 14223 Section ID :- C Name :- Nishant Patel Homework :-9
Image of page 1
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.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Summer '19
  • Oracle Database, schema object auditing

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture