RelationalDBDesign RelationalDBDesign


Managing Users   «Prev 

Exploring Security Manager

  1. You need to log into a database. Enter system in the Username field and press Tab to advance to the password field. Type dogtoad in the Password field and press Tab to advance to the service field. Next, tell Enterprise Manager which database you want to connect to. Type coin in the Service field and click the OK button.
  2. This is the opening screen that you will see after connecting to the database. From here, you can click either Users or Roles in the left pane to see information about that item. You can expand the Roles item by clicking the + next to it. Click the close box in the upper right corner to exit.
  3. A list of database users is displayed on the right-hand side of the screen. From here, you can click any of the items in the left pane to see information about that item. You can expand the Roles item by clicking the + next to it. Click the close box in the upper right corner to exit.
  4. A list of database roles is displayed. From here, you can click either Roles or Users in the left pane to see information about that item. You can expand the Roles item by clicking the + next to it. Click the close box in the upper right corner to exit.
  5. A list of database roles is displayed in the left-hand portion of the window. Click on Users, Roles, or DBA in the left paneto view more information. Click the close box in the upper right corner to exit.
  6. Clicking the DBA role causes the definition for that role to be displayed on the right-hand side of the screen. The definition is broken up into four areas: General, Role, System Privileges, and Object Privileges. Each area has its own tab. From here, you can click Users or Roles in the left pane to see information about that item. You can close the Roles folder by clicking the - next to it. You can also click the tabs at the top of the right-hand pane. Click the close box in the upper right corner to exit.
  7. A list of system privileges that have been granted to the role is displayed. From here, you can click Users or Roles in the left pane to see information about that item. You can close the Roles folder by clicking the - next to it. You can also click the DBA role in order to see detailed information about that role. Click the close box in the upper right corner to exit.
  8. The Role s tab shows a list of roles that have been granted to the DBA role. From here, you can click Users or Roles in the left pane to see information about that item. You can close the Roles folder by clicking the - next to it. You can also click any of the tabs at the top of the right-hand pane. Click the close box in the upper right corner to exit.
  9. The object privileges tab lists any object privileges that have been granted to the role. From here, you can click the Users or Roles folders in the left pane to see information about that item. You can close the Roles folder by clicking the - next to it. You can also click any of the tabs at the top of the right-hand pane. Click the close box in the upper right corner or the exit button to end this simulation.