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 -
Refresh : Will refresh all tabs in the security manager from the database
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create User: Create new user
Edit User: Edit selected user
Drop User: Drop selected user
User Properties: View properties of selected user
Create Role: Create new role
Edit Role: Edit selected role
Drop Role: Drop selected role
Role Properties: View properties of selected role
Create Profile: Create new profile
Edit Profile: Edit profile
Drop Profile: Drop selected profile
Profile Properties: View properties of selected profile
|
General 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
|
 Oracle DBA Tools - Security Manager - General Tab |
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
|
 Oracle DBA Tools - Security Manager - Users Tab |
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}
|
 Oracle DBA Tools - Security Manager - Roles Tab |
Profiles Tab - Provides a list of profiles in the Oracle database
Name: Profile name
Composite Limit: Total resource cost for a session
Private SGA: Specify 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: Specify the elapsed time allowed for a session measured in minutes
Idle Time: Idle time before a connection is closed
|
 Oracle DBA Tools - Security Manager - Profiles Tab |
