User access to the database
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
User access to the database
Every user must connect to the database using an authorized userid and password. Questions you’ll have to address include the following:
Will users share one or more common userids (this is common with many vendor applications) or will each user have a unique userid?
Should passwords expire after a period of time?
Do you need to implement a minimum length for passwords or impose other content restrictions?
Do you want to limit the number of concurrent sessions for a given user?
Will users be able to create their own objects?
Will you be able to restrict access to DBA or other privileged accounts?
Will the database be accessible for remote connections using SQL*Net or Net8?
Will the database be accessible for distributed queries?
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.