Navicat what method to use to detect Oracle database security

Source: Internet
Author: User
Tags oracle documentation sqlite

Navicat for Oracle is a powerful set of Oracle database system management tools. It can run in more than 8i versions of Oracle database and supports most of its latest features. and help Oracle Beginners Learn how to use them quickly. Some users of navicat in what way to detect the security of Oracle database is more puzzled, we will come to this issue to share with you.


Navicat Users

In addition to user-created accounts, databases include automatic creation of several user-managed accounts, SYS, SYSTEM, Sysman, and Dbsnmp when installed. Managing accounts is a high-privileged account that can be used for administrative tasks. Examples include starting or stopping a database, managing database memory and storage areas, creating and managing database users, and so on. The user's database can also include a set of interrelated patterns, Oracle Documentation and Oracle Education tool descriptions, common database schema Samples (SCOTT, HR, OE, OC, PM, IX, and SH).

When a user creates a database object, the user becomes its owner. By default, only the owner of an object can have permission to manipulate an object. If you let other users share the object, you must grant other object permissions, but users with Superuser properties can access any object.

Typically, only the owner (or Superuser) of an object can grant or revoke permissions on an object. However, when granting the permission "administrative options" or "Grant options" to the recipient, there is also a right to grant to others, and if the grant option is later revoked, all recipients who receive the permission from the recipient (including direct or concise authorization) will lose their permissions.

Warm tip: Special name public each database user can access, all permissions and roles are granted to public, each database user has access rights.

The above is the introduction of what method Navicat use to detect the security of Oracle database, if you do not understand where you can refer to the relevant tutorials, such as: You do not know how to install Navicat for SQLite, you can refer to Navicat for SQLite Installation Diagram .

Navicat what method to use to detect Oracle database security

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.