Users and Security Security domain The database administrator defines the names of the users who are allowed to access a database. A security domain defines the settings that apply to the user. Authentication mechanism A user who requires access to the database can be authenticated by one of the following: Data dictionary Operating system Network The means of authentication is specified at the time the user is defined in the database and can be altered later. This lesson covers authentication by database and by operating system only. Note: Refer to the “Getting Started with the Oracle Server” lesson for details regarding operating system authentication using roles. Authentication through the. | Managing Users Objectives After completing this lesson, you should be able to do the following: Create new database users Alter and drop existing database users Monitor information about existing users Obtain user information Account locking Tablespace quotas Temporary tablespace Default tablespace Role privileges Resource limits Security domain Direct privileges Authentication mechanism Users and Security Users and Security Security domain The database administrator defines the names of the users who are allowed to access a database. A security domain defines the settings that apply to the user. Authentication mechanism A user who requires access to the database can be authenticated by one of the following: Data dictionary Operating system Network The means of authentication is specified at the time the user is defined in the database and can be altered later. This lesson covers authentication by database and by operating system only. Note: Refer to the “Getting Started with the Oracle Server” lesson for details regarding operating system authentication using roles. Authentication through the network is covered in the Oracle9i Database Administration Fundamentals II course. Users and Security (continued) Tablespace quotas Tablespace quotas control the amount of physical storage space that is allocated to a user in the tablespaces in the database. Default tablespace The default tablespace defines the location where segments that are created by a user are stored if the user does not explicitly specify a tablespace at the time the segment is created. Temporary tablespace Temporary tablespace defines where extents will be allocated by the Oracle server if the user performs an operation that requires writing sort data to the disk. Account locking Accounts can be locked to prevent a user from logging on to the database. This can be set to occur automatically, or the database administrator can lock and unlock accounts manually. Resource limits Limits can be placed on the | Managing Users Objectives After completing this lesson, you should be able to do the following: Create new database users Alter and drop existing database users Monitor information about existing users Obtain user information Account locking Tablespace quotas Temporary tablespace Default tablespace Role privileges Resource limits Security domain Direct privileges Authentication mechanism Users and Security Users and Security Security domain The database administrator defines the names of the users who are allowed to access a database. A security domain defines the settings that apply to the user. Authentication mechanism A user who requires access to the database can be authenticated by one of the following: Data dictionary Operating system Network The means of authentication is specified at the time the user is defined in the database and can be altered later. This lesson covers authentication by database and by operating system only. Note: Refer to the “Getting Started with the .
