Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the knowledge points of Oracle users, permissions and role management". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what are the knowledge points of Oracle users, permissions and role management"?

1.Oracle user

Oracle users, users who can log in to the Oracle database and add, delete, modify and query the database. There are four main types of users:

Super Admin, such as SYS

Ordinary administrator, such as SYSTEM

Ordinary users, such as SCOTT

Big data users

1. Create a user:

two。 Delete user

If the user owns the object, it cannot be deleted directly, otherwise an error value will be returned. At this point, you can use the specified keyword cascade to delete all objects owned by the user, and then delete the user.

Temporary users, especially those who do not need to create tables, are usually only given connect role. Connect uses oracle simple permissions, which only have access to other users' tables, including select/insert/update and delete.

Users with connect role can also create chains of tables, views, sequences (sequence), clusters (cluster), synonyms (synonym), replies (session) and other data (link).

2) resource role (resource role)

More reliable and formal database users can be awarded to resource role. Resource gives users additional permissions to create their own tables, sequences, procedures (procedure), triggers (trigger), indexes (index), and clusters (cluster).

3) dba role (database administrator role)

Dba role has all system permissions. This includes unlimited space limits and the ability to grant various permissions to other users. System is owned by dba users

In addition to the three system roles mentioned earlier, users can create their own roles in Oracle

-- 1) create roles

-Grammar:

Create role role name

-- example:

Create role testRole

-- 2) authorized roles

-Grammar:

Grant select on class (table name) to role name

-- example:

Grant select on class to testRole

-- 3) Delete roles

-Grammar:

Drop role role name

-- example:

Drop role testRole

Note: after authorization, all users with the testRole role will have select query permissions on the class table; after deletion, all permissions related to the testRole role will be deleted from the database

At this point, I believe you have a deeper understanding of "what are the knowledge points of Oracle users, permissions and role management?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.