Oracle DBA Tools - Security Manager Provides manageability of users, roles and profiles. Allowing the user to manage permissions, roles and security of the Oracle database. | |
Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available. Available operations for Tree tab Available operations for Users tab Available operations for Roles tab Available operations for Profiles tab | |
Tree Tab - Provides a tree display of the users, roles and profiles for the Oracle database. Selecting an object in the tree structure will display a detailed view of the object on the right pane. | |
Users Tab - Provides a list of users in the Oracle database Name: Name of the user Default Tablespace: Default tablespace for data Temp Tablespace: Name of the default tablespace for temporary table or the name of a tablespace group Profile: User resource profile name Created Date: User creation date Status: Account status Locked Date: Date the account was locked Expiration Date: Date the account expires | |
Roles Tab - Provides a list of roles in the Oracle database Name: Name of the role Password Required: Indicates if the role requires a password to be enabled Authentication: Authentication that is required {NONE, PASSWORD, GLOBAL, EXTERNAL} | |
Profiles Tab - Provides a list of profiles in the Oracle database Name: Profile name Composite Limit: Total resource cost for a session Private SGA: Specifies the number of bytes of private space in the system global area (SGA) that can be used by a session. This limit applies only if you are using Shared Server architecture and allocating private space in the SGA for your session. Connect Time: Specifies the elapsed time allowed for a session measured in minutes Idle Time: Idle time before a connection is closed |