This document would mainly focouss on SQL,PL/SQL and third party Programming tool as a middleware, and would restrain in probing admin aspects of Oracle, Postgql and MySql database.

In the following document I would just browse the salient feature to accomplish my main target, that is querying db over an intranet environment.

I would consider Oracle DB documents as a base template  while comparing with other db.

• DB installation
  • http://docs.oracle.com/cd/B28359_01/server.111/b28337.pdf#E6.BABBIDAJ
  • default setting and privileges
    • ch 7-5
    • Data disctionary
      • schema objects
        • talbes, views, indesces, clusters, synonyms, sequences, procedures, functions, triggers
        • Default values of columns, Integrity constraints
        • DB Users roles and privileges
  • new or change password
  • manage external job privileges
• User accounts : ch3
  • http://docs.oracle.com/cd/B28359_01/server.111/b28337.pdf#E7.BABDBGIJ
  • securing db user accounts
  • predefined user accounts
  • exprining and locking user accounts
  • creaing password
  • finding and changing password
  • guide to admin user pwd
  • guide to pwd management
• Understanding of privileges
  • http://docs.oracle.com/cd/B28359_01/server.111/b28337.pdf#E8.CHDFEBAB
• Encrypting sensitive data

Clock on configuring assistant

Select database configuration option

Revealing Scott ?details tab

table lcok