محدودیت برای یوزرها در اوراکل

با استفاده از PROFILES در اوراکل مي توانيم براي يوزرها محدوديت ايجاد كنيم.

RESOURCES REGULATED AT THE SESSION LEVEL:

1-SYSTEM RESOURCE: DEFINITION
2-CPU_PER_SESSION: total CPU time in hundreds of seconds
3-SESSIONS_PER_USER: number of concurrent sessions for a user
4-CONNECT_TIME: allowed connection time in minutes
5-IDLE_TIME: inactive time on the server in minutes
6-LOGICAL_READS_PER_SESSION : number of data blocks read including both physical and logical reads from memory and disk
7-PRIVATE_SGA: bytes of SGA used in a database with the multithreaded server (in K or M)

طريقه اجرا:

CREATE PROFILE profile LIMIT resource_parameters|password_parameters
Resource_parameters (you can specify multiple paramters per command):
[SESSIONS_PER_USER n|UNLIMITED|DEFAULT] [CPU_PER_SESSION n|UNLIMITED|DEFAULT] [CPU_PER_CALL n|UNLIMITED|DEFAULT] [CONNECT_TIME n|UNLIMITED|DEFAULT] [IDLE_TIME n|UNLIMITED|DEFAULT] [LOGICAL_READS_PER_SESSION n|UNLIMITED|DEFAULT] [LOGICAL_READS_PER_CALL n|UNLIMITED|DEFAULT] [COMPOSITE_LIMIT n|UNLIMITED|DEFAULT] [PRIVATE_SGA n [K|M]|UNLIMITED|DEFAULT] …

همچنين با “QUOTA” در اوراکل مي توان مقدار فضاي كه يك يوزر مي تواند در يك tablespace خاص ديتا ذخيره كند را مشخص کرد.
مثال:

CREATE USER saeed
IDENTIFIED BY password
DEFAULT TABLESPACE data_ts
QUOTA 100M ON test_ts
QUOTA 500K ON data_ts
TEMPORARY TABLESPACE temp_ts
PROFILE clerk