ORACLEprofile limit maid 4 -- CREATEPROFILE

ORACLEprofile limit maid 4 -- CREATEPROFILE

Â Â Æ ª ² Í Ê çoracle profile Ï µá Ð µäzúä ä£ £%öö %%%%%%µ%» â  £%%%%%%%%%%%%%%%%%%%%%%%%%%% comment ''¨ profile ° Í Ê Ó Ã profile ø Ø Ð × Ê Ô'' ° Í Ü Â ë ø ööö

CREATE PROFILE

Note:

Oracle recommends that you use the Database Resource Manager rather than this SQL statement to establish resource limits. the Database Resource Manager offers a more flexible means of management and tracking resource use. for more information on the Database Resource Manager, refer to Oracle Database Administrator's Guide.

Purpose

Use the create profile statement to create a profile, which is a set of limits on database resources. If you assign the profile to a user, then that user cannot exceed these limits.

See Also:

Oracle Database Security Guide for a detailed description and explanation of how to use password management and protection

Prerequisites

To create a profile, you must have the create profile system privilege.

To specify resource limits for a user, you must:

Enable resource limits dynamically with the alter system statement or with the initialization parameterRESOURCE_LIMIT. This parameter does not apply to password resources. Password resources are always enabled.

Create a profile that defines the limits using the create profile statement

Assign the profile to the user using the create user orALTER USER statement

# ''%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

When there are too many registrars, there are still too many ''of them, the names of the users who have their names, the names of the users who have their names

~%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ~~~~%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Zookeeper zookeeper resource _ limit zookeeper ~äüz£ (************************************************** ú² Î Ê Ä ä¼ öð öö¸ {{| RESOURCE _ LIMIT ³ õ Ê ¼» ² Î £» ò Ö ö± ½ Ó ¹ criteria alter system set resource_limit = true; À 'Æ ô ónó)

See Also:

Alter system for information on enabling resource limits dynamically

Oracle Database Reference for information on theRESOURCE_LIMIT parameter

Create user andALTER USER for information on profiles

Syntax

Create_profile: =

Description of the authentication create_profile.gif

Resource_parameters: =

Description of the procedure resource_parameters.gif

(Size_clause: =

Password_parameters: =

VcmRfcGFyYW1ldGVycy5naWYgZm9sbG93cw = "src =" http://www.bkjia.com/uploads/allimg/141112/04115T958-2.gif "width =" 374 "height =" 284 ">
Description of the authentication password_parameters.gif

Examples

Creating a Profile: Example The following statement creates the profilenew_profile:

CREATE PROFILE new_profile  LIMIT PASSWORD_REUSE_MAX 10        PASSWORD_REUSE_TIME 30;

Setting Profile Resource Limits: Example The following statement creates the profileapp_user:

CREATE PROFILE app_user LIMIT    SESSIONS_PER_USER          UNLIMITED    CPU_PER_SESSION            UNLIMITED    CPU_PER_CALL               3000    CONNECT_TIME               45    LOGICAL_READS_PER_SESSION  DEFAULT    LOGICAL_READS_PER_CALL     1000    PRIVATE_SGA                15K   COMPOSITE_LIMIT            5000000; 

If you assign the app_user profile to a user, then the user is subject to the following limits in subsequent sessions:

The user can have any number of concurrent sessions.

In a single session, the user can consume an unlimited amount of CPU time.

A single call made by the user cannot consume more than 30 seconds of CPU time.

A single session cannot last for more than 45 minutes.

In a single session, the number of data blocks read from memory and disk is subject to the limit specified in theDEFAULT profile.

A single call made by the user cannot read more than 1000 data blocks from memory and disk.

A single session cannot allocate more than 15 kilobytes of memory in the SGA.

In a single session, the total resource cost cannot exceed 5 million service units. The formula for calculating the total resource cost is specified by theALTER resource cost statement.

Since the app_user profile omits a limit for IDLE_TIME and for password limits, the user is subject to the limits on these resources specified in theDEFAULT profile.

Setting Profile Password Limits: Example The following statement creates theapp_user2 profile with password limits values set:

CREATE PROFILE app_user2 LIMIT   FAILED_LOGIN_ATTEMPTS 5   PASSWORD_LIFE_TIME 60   PASSWORD_REUSE_TIME 60   PASSWORD_REUSE_MAX 5   PASSWORD_VERIFY_FUNCTION verify_function   PASSWORD_LOCK_TIME 1/24   PASSWORD_GRACE_TIME 10;

This example uses the default Oracle Database password verification function, verify_function. Refer to Oracle Database Security Guide for information on using this verification function provided or designing your own verification function.