Privileges Required to Collect Oracle LMS Data

  • The following database privileges are required to collect Oracle LMS data. These privileges must be granted to the DB user whose credentials are used to gather the data.

    • CREATE SESSION
    • SELECT ANY TABLE
    • SELECT ANY DICTIONARY (for Oracle 9i or higher)
    • When DATABASE VAULT is in use, PARTICIPANT or OWNER authorization on "Oracle Database Vault Realm" is needed
  • Shell access to the operating system command line (UNIX Shell or Windows Command Prompt) through the corresponding Shell protocol of Universal Discovery (SSH, NTCMD, PowerCmd, or Universal Discovery) is required.

  • On Linux, root access is required. If it is missing, a warning message is shown.