Management of Oracle 9i profiles

To create a profile in Enterprise Manager

(1) as shown in Figure 8.26.

(2) The General Information tab of the Create profile as shown in Figure 8.27 appears.

(3) Figure 8.28 shows the Password tab to create the profile.

(4) The interface appears as shown in Figure 8.29.

(5) The SQL code to create the profile according to the above configuration is as follows.
―――――――――――――――――――――――――――――――――――――
CREATE profile "Tempprofile"
/* "General Information" tab corresponding configuration parameters.
LIMIT Cpu_per_session 1000
Cpu_per_call 1000
Connect_time 30
Idle_time DEFAULT
Sessions_per_user 10
Logical_reads_per_session 1000
Logical_reads_per_call 1000
PRIVATE_SGA 16K
Composite_limit 1000000
/* "Password" tab corresponding to the configuration parameters * *
Failed_login_attempts 3
Password_lock_time 5
Password_grace_time 60
Password_life_time 30
Password_reuse_max
DEFAULT Password_reuse_time 30
Password_verify_function DEFAULT
―――――――――――――――――――――――――――――――――――――
"See CD-ROM File": 8th Chapter \createprofile.sql.

Create a profile in "Sqlplus Worksheet"

Executing the Createprofile.sql file directly in "Sqlplus Worksheet" will complete the profile creation, as shown in Figure 8.30. Indicates that the profile Tempprofile has been successfully created.


Modification of the profile

(1) as shown in Figure 8.31.

(2) in the General Information and Password tab of the edited profile that appears, you can modify the profile configuration parameters, and the SQL statement corresponding to the modified profile is "ALTER profiles."
instance: The SQL code that sets the cpu/session parameter to 6000 is as follows.
―――――――――――――――――――――――――――――――――――――
ALTER profile "Tempprofile" LIMIT cpu_per_session 6000
―――――――――――――――――――――――――――――――――――――
"See CD-ROM File": 8th Chapter \alterprofile.sql.

Assign a profile to a user

(1) as shown in Figure 8.32, "allocation Profile" interface.

(2) The corresponding SQL code for the above process is as follows.
―――――――――――――――――――――――――――――――――――――
ALTER USER Tempuser profile Tempprofile;
―――――――――――――――――――――――――――――――――――――
"See CD-ROM File": 8th Chapter \alteruserprofile.sql.

Deletion of profile

(1) as shown in Figure 8.33, "Profile deletion confirmation" interface.
(2) The SQL code to delete the profile is as follows.
―――――――――――――――――――――――――――――――――――――
DROP Profile Tempprofile
―――――――――――――――――――――――――――――――――――――
"See CD-ROM File": 8th Chapter \dropprofile.sql.