TAILIEUCHUNG - Managing Users - 15

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

• Cơ sở dữ liệu
• Managing Users
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Linux essentials
• Module Linux essentials
• Managing groups
• Account information
• Password security
• Defining the Position
• Managing Standards
• Financial Processes
• Managing Software
• Managing Your Man
• Installing Liferay
• Creating Portal Pages
• Managing Portal Users
• Facilitating Collaboration
• Establishing a Wiki
• Managing Content
• Managing profile
• Existing Modules
• HTML module
• Configuring RSS
• Structured Query Language
• công nghệ thông tin
• tin học
• mạng máy tính
• internet
• hệ điều hành
• quản trị mạng
• thiết kế
• đồ họa
• information technology
• microsoft windows
• Exchange Server
• Exchange Transport
• Routing
• LPI 102 Junior Level Administration
• Junior Level Administration
• The Linux Documentation
• Shells Scripting
• Shutdown and Runlevels
• hệ điều hành linux
• tài liệu linux LPI
• quản lý user
• user ID
• virus
• chứng chỉ quốc tế
• curriculum
• Oracle Database
• Database Concepts
• Windows 2003 Server
• Microsoft Certified Systems Engineer
• Microsoft Corporation
• MICROSOFT EXAM