2/19

List of Examples

• 2-1 Creating a User Account with the CREATE SESSION Privilege
• 2-2 Altering a User Account
• 2-3 Using ORAPWD to Change the SYS User Password
• 2-4 Querying V$SESSION for the Session ID of a User
• 2-5 Killing a User Session
• 2-6 Finding Objects Owned by a User
• 2-7 Dropping a User Account
• 3-1 Password Creation SQL Statements
• 3-2 Locking an Account with the CREATE PROFILE Statement
• 3-3 Setting Password Aging and Expiration with CREATE PROFILE
• 3-4 Enabling Password Case Sensitivity
• 3-5 Sample SQLNET.ORA File with Wallet Parameters Set
• 4-1 Setting O7_DICTIONARY_ACCESSIBILITY to FALSE
• 4-2 Creating a User Role Authorized by a Password
• 4-3 Altering a Role to be Authorized by an External Source
• 4-4 Using SET ROLE for a Password-Authenticated Role
• 4-5 Creating a Role Authorized by a PL/SQL Package for an Application
• 4-6 Creating a Role Authorized by an External Source
• 4-7 Creating a Global Role
• 4-8 Revoking All Object Privileges Using CASCADE CONSTRAINTS
• 4-9 Compiling a Procedure
• 4-10 Package Objects Affected by Procedure Privileges
• 4-11 Granting a System Privilege and a Role to a User
• 4-12 Granting the EXECUTE Privilege on a Directory Object
• 4-13 Granting the ADMIN Option
• 4-14 Creating a New User with the GRANT Statement
• 4-15 Granting Object Privileges to Users
• 4-16 Using SET ROLE to Grant a Role and Specify a Password
• 4-17 Using SET ROLE to Disable All Roles
• 4-18 Using ALTER USER to Set Default Roles
• 4-19 Creating an Access Control List for a Single Role and Network Connection
• 4-20 Creating an Access Control List for Multiple Roles and Network Connections
• 4-21 Using the DBA_NETWORK_ACL_PRIVILEGES View to Show Granted Privileges
• 4-22 Using the DBA_NETWORK_ACLS View to Show Host Assignments
• 4-23 Configuring ACL Access Using Passwords in a Non-Shared Wallet
• 4-24 Configuring ACL Access for a Wallet in a Shared Database Session
• 4-25 Administrator Checking User Permissions for Network Host Connections
• 4-26 Administrator Checking Permissions for Domain Name Resolution
• 4-27 User Checking Permissions for Network Host Connections
• 4-28 User Checking Privileges for Domain Name Resolution
• 5-1 Java Code for Reading Passwords
• 6-1 Creating a Database Session-Based Application Context
• 6-2 Finding SYS_CONTEXT Values
• 6-3 Simple Procedure to Create an Application Context Value
• 6-4 Creating a Simple Logon Trigger
• 6-5 Creating a Logon Trigger for a Production Environment
• 6-6 Creating a Logon Trigger for a Development Environment
• 6-7 Package to Retrieve Session Data and Set a Database Session Context
• 6-8 Creating an Externalized Database Session-based Application Context
• 6-9 Creating a Global Application Context
• 6-10 Package to Manage Global Application Values for All Database Users
• 6-11 Package to Manage Global Application Context Values for a User Moving Between Applications
• 6-12 Package to Manage Global Application Context Values for Nondatabase Users
• 6-13 Using OCIStmtExecute to Retrieve a Client Session ID Value
• 6-14 Retrieving a Client Session ID Value for Client Session-Based Contexts
• 7-1 Attaching a Simple Oracle Virtual Private Database Policy to a Table
• 7-2 Specifying SQL Statement Types with DBMS_RLS.ADD_POLICY
• 7-3 Creating a Column-Level Oracle Virtual Private Database Policy
• 7-4 Adding a Column Masking to an Oracle Virtual Private Database Policy
• 7-5 Creating a DYNAMIC Policy with DBMS_RLS.ADD_POLICY
• 7-6 Creating a STATIC Policy with DBMS_RLS.ADD_POLICY
• 7-7 Creating a SHARED_STATIC Policy with DBMS_RLS.ADD_POLICY
• 7-8 Creating a CONTEXT_SENSITIVE Policy with DBMS_RLS.ADD_POLICY
• 7-9 Creating a SHARED_CONTEXT_SENSITIVE Policy with DBMS_RLS.ADD_POLICY
• 9-1 Checking the Current Value of the AUDIT_TRAIL Initialization Parameter
• 9-2 Enabling the Standard Audit Trail
• 9-3 Text File Operating System Audit Trail
• 9-4 XML File Operating System Audit Trail
• 9-5 Syslog Audit Trail for SYS User
• 9-6 Using AUDIT to Audit User Actions
• 9-7 Using AUDIT to Enable SQL Statement Auditing
• 9-8 Auditing Unsuccessful Statements
• 9-9 Using NOAUDIT to Remove Session and SQL Statement Auditing
• 9-10 Using NOAUDIT to Remove ALL STATEMENTS Auditing
• 9-11 Using AUDIT to Configure Privilege Auditing
• 9-12 Using AUDIT to Audit a SQL Statement for a User
• 9-13 Configuring Auditing for a Schema Table
• 9-14 Auditing Successful Statements on a Schema Table
• 9-15 Configuring Auditing for Any New Objects Using the DEFAULT Clause
• 9-16 Auditing the Execution of a Procedure or Function
• 9-17 Auditing a Directory Object
• 9-18 Auditing All Functions, Procedures, Packages, and Triggers
• 9-19 Auditing a User's Execution of Functions, Procedures, Packages, and Triggers
• 9-20 Auditing the Execution of a Procedure or Function within a Schema
• 9-21 Using DBMS_FGA.ADD_POLICY to Create a Fine-Grained Audit Policy
• 9-22 Disabling a Fine-Grained Audit Policy
• 9-23 Enabling a Fine-Grained Audit Policy
• 9-24 Dropping a Fine-Grained Audit Policy
• 9-25 Auditing Table Insert Operations by User SYSTEM
• 9-26 Audit Trigger to Record Before and After Changes to a Table
• 9-27 Directly Calling a Database Audit Trail Purge Operation