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

This article mainly introduces "the creation, modification and deletion of common syntax for dm database users". In daily operation, I believe that many people have doubts about the creation, modification and deletion of common syntax for dm database users. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "dm database users' creation, modification and deletion of common syntax". Next, please follow the editor to study!

In the daily maintenance operation of dm database, the addition, deletion and authorization of database users are essential. This paper introduces the common syntax of creating, modifying and deleting dm database users.

View pre-built users of the system:

2. The space restriction clause is used to limit the maximum storage space used by users. Values range from 1 to 1048576 in M, and the keyword UNLIMITED indicates no limit.

3. Password policy, allow IP, disable IP, allow time period, disable time period and external authentication functions are only available in the secure version

4. User default tablespaces and index default tablespaces cannot use SYSTEM, RLOG, ROLL, TEMP tablespaces.

The common resource options are configured as shown in the following table:

Resource setting item

Description

Maximum value

Minimum value

Default value

CONNECT_TIME

Time limit for a session to connect, access, and operate the database server (in 1 minute)

1440 (1 day)

one

No limit

CONNECT_IDLE_TIME

Maximum idle time of the session (in 1 minute)

1440 (1 day)

one

No limit

FAILED_LOGIN_ATTEMPS

The number of consecutive registration failures that will cause an account to be locked

one hundred

one

three

PASSWORD_LIFE_TIME

The number of days a password can be used before it is terminated

three hundred and sixty five

one

No limit

PASSWORD_LOCK_TIME

If the FAILED_LOGIN_ATTEMPS setting value is exceeded, the number of minutes an account will be locked

1440 (1 day)

one

one

Highlights compared with ORACLE:

1. The configurable read-only flag indicates whether the login can only be read-only to the database. The default is read-write.

2. IP can be allowed and IP can be prohibited. Used to control whether this login can access the database from an IP, where IP is prohibited first. When setting IP, you can use * to set the network segment, such as 192.168.0.*. Set allow and disable IP need to be enclosed in double quotation marks

3. You can configure allow time periods and disable time periods to log in. Used to control whether this login can access the database for a certain period of time, where the forbidden period takes precedence. The date and time in the set time period should be enclosed in double quotation marks respectively. When setting up time intervals, there are two ways:

1) specific time periods, such as 8:30 on 1 January 2016 to 17:00 on 1 February 2006

2) regular time period, such as 8:30 every Monday to 17:00 every Friday.

Second, modify the syntax commonly used by database users

Alter user IDENTIFIED....

Same as the parameter specification of CREATE USER.

III. User deletion statement

DROP USER [RESTRICT | CASCADE]

Note:

1. The three system users SYSDBA, SYSAUDITOR and SYSSSO created automatically by the system cannot be deleted.

2. If the CASCADE option is used, DM will automatically delete referential integrity constraints and view dependencies if a table created by another user references a primary or unique keyword on the user table, except for the user and all objects created in the database, or creates a view on the table.

At this point, on the "dm database users to create, modify and delete common syntax" study is over, I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.