{"id":11896,"date":"2023-10-01T07:54:02","date_gmt":"2023-10-01T06:54:02","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=11896"},"modified":"2023-10-31T11:35:19","modified_gmt":"2023-10-31T10:35:19","slug":"profili-profiles","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2023\/10\/01\/profili-profiles\/","title":{"rendered":"Profili ( Profiles )"},"content":{"rendered":"\n<p>Profili nam omogo\u010dajo, da reguliramo uporabo sistemskih virov za posameznega uporabnika. Privzeti profil je DEFAULT. Profili so bili uvedeni v verziji 8.<\/p>\n\n\n\n<p>Profile za posameznika lahko prika\u017eemo takole:<\/p>\n\n\n\n<p>SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"395\" height=\"146\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-6.png\" alt=\"\" class=\"wp-image-11898\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-6.png 395w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-6-300x111.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/figure>\n\n\n\n<p>Lahko pogledamo vse vire za DEFAULT profile<\/p>\n\n\n\n<p><br>SELECT * FROM<br>dba_profiles<br>WHERE<br>PROFILE = &#8216;DEFAULT&#8217;<br>ORDER BY<br>resource_type,<br>resource_name;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"362\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-8.png\" alt=\"\" class=\"wp-image-11905\" srcset=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-8.png 670w, https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-8-300x162.png 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/figure>\n\n\n\n<p>Link: <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/CREATE-PROFILE.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/CREATE-PROFILE.html<\/a><\/p>\n\n\n\n<p>CREATE PROFILE profile<br>LIMIT { resource_parameters<br>| password_parameters<br>}\u2026<br>[ CONTAINER = { CURRENT | ALL } ] ;<\/p>\n\n\n\n<p id=\"GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3__GUID-E39008BB-092E-49B2-AAC2-3C4A98FC9A03\"><em><strong>resource_parameters<\/strong><\/em><\/p>\n\n\n\n<p><strong>SESSIONS_PER_USER<\/strong><\/p>\n\n\n\n<p>Specify the number of concurrent sessions to which you want to limit the user.<\/p>\n\n\n\n<p><strong>CPU_PER_SESSION<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the CPU time limit for a session, expressed in hundredth of seconds.<\/p>\n\n\n\n<p><strong>CPU_PER_CALL<\/strong><a><\/a><a><\/a><\/p>\n\n\n\n<p>Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.<\/p>\n\n\n\n<p><strong>CONNECT_TIME<\/strong><\/p>\n\n\n\n<p>Specify the total elapsed time limit for a session, expressed in minutes.<\/p>\n\n\n\n<p><strong>IDLE_TIME<\/strong><\/p>\n\n\n\n<p>Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.<\/p>\n\n\n\n<p>When you set an idle timeout of X minutes, note that the session will take a couple of additional minutes to be terminated.<\/p>\n\n\n\n<p>On the client application side, the error message shows up only the next time, when the idle client attempts to issue a new command.<\/p>\n\n\n\n<p><strong>LOGICAL_READS_PER_SESSION<\/strong><\/p>\n\n\n\n<p>Specify the permitted number of data blocks read in a session, including blocks read from memory and disk.<\/p>\n\n\n\n<p><strong>LOGICAL_READS_PER_CALL<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the permitted number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch).<\/p>\n\n\n\n<p><strong>PRIVATE_SGA<\/strong><\/p>\n\n\n\n<p>Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA). Refer to&nbsp;<em><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/size_clause.html#GUID-E97FADC2-A6E1-4D68-9F79-DCA271B86517\">size_clause<\/a><\/em>&nbsp;for information on that clause.<\/p>\n\n\n\n<p>Note:<\/p>\n\n\n\n<p>This limit applies only if you are using shared server architecture. The private space for a session in the SGA includes private SQL and PL\/SQL areas, but not shared SQL and PL\/SQL areas.<\/p>\n\n\n\n<p><strong>COMPOSITE_LIMIT<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the total resource cost for a session, expressed in&nbsp;<strong>service units<\/strong>. Oracle Database calculates the total service units as a weighted sum of&nbsp;<code>CPU_PER_SESSION<\/code>,&nbsp;<code>CONNECT_TIME<\/code>,&nbsp;<code>LOGICAL_READS_PER_SESSION<\/code>, and&nbsp;<code>PRIVATE_SGA<\/code>.<\/p>\n\n\n\n<p id=\"GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3__GUID-D8EE606A-E1F6-40E9-8970-7FB717BF9CC5\"><em><strong>password_parameters<\/strong><\/em><\/p>\n\n\n\n<p>Use the following clauses to set password parameters. Parameters that set lengths of time\u2014that is, all the password parameters except&nbsp;<code>FAILED_LOGIN_ATTEMPTS<\/code>&nbsp;and&nbsp;<code>PASSWORD_REUSE_MAX<\/code>\u2014are interpreted in number of days. For testing purposes you can specify minutes (<em>n<\/em>\/1440) or even seconds (<em>n<\/em>\/86400) for these parameters. You can also use a decimal value for this purpose (for example .0833 for approximately one hour). The minimum value is 1 second. The maximum value is 24855 days. For&nbsp;<code>FAILED_LOGIN_ATTEMPTS<\/code>&nbsp;and&nbsp;<code>PASSWORD_REUSE_MAX<\/code>, you must specify an integer.<\/p>\n\n\n\n<p><strong>FAILED_LOGIN_ATTEMPTS<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the number of consecutive failed attempts to log in to the user account before the account is locked. If you omit this clause, then the default is 10 times.<\/p>\n\n\n\n<p><strong>PASSWORD_LIFE_TIME<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the number of days the same password can be used for authentication. If you also set a value for&nbsp;<code>PASSWORD_GRACE_TIME<\/code>, then the password expires if it is not changed within the grace period, and further connections are rejected. If you omit this clause, then the default is 180 days.<\/p>\n\n\n\n<p>See Also:<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/pls\/topic\/lookup?ctx=en\/database\/oracle\/oracle-database\/19\/sqlrf&amp;id=DBSEG567\" target=\"_blank\" rel=\"noreferrer noopener\"><em>Oracle Database Security Guide<\/em><\/a>&nbsp;for information on setting&nbsp;<code>PASSWORD_LIFE_TIME<\/code>&nbsp;to a low value<\/p>\n\n\n\n<p><strong>PASSWORD_REUSE_TIME<\/strong><a><\/a>&nbsp;<strong>and PASSWORD_REUSE_MAX<\/strong><a><\/a><\/p>\n\n\n\n<p>These two parameters must be set in conjunction with each other.&nbsp;<code>PASSWORD_REUSE_TIME<\/code>&nbsp;specifies the number of days before which a password cannot be reused.&nbsp;<code>PASSWORD_REUSE_MAX<\/code>&nbsp;specifies the number of password changes required before the current password can be reused. For these parameter to have any effect, you must specify a value for both of them.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If you specify a value for both of these parameters, then the user cannot reuse a password until the password has been changed the number of times specified for&nbsp;<code>PASSWORD_REUSE_MAX<\/code>&nbsp;during the number of days specified for&nbsp;<code>PASSWORD_REUSE_TIME<\/code>.For example, if you specify&nbsp;<code>PASSWORD_REUSE_TIME<\/code>&nbsp;to 30 and&nbsp;<code>PASSWORD_REUSE_MAX<\/code>&nbsp;to 10, then the user can reuse the password after 30 days if the password has already been changed 10 times.<\/li>\n\n\n\n<li>If you specify a value for either of these parameters and specify&nbsp;<code>UNLIMITED<\/code>&nbsp;for the other, then the user can never reuse a password.<\/li>\n\n\n\n<li>If you specify&nbsp;<code>DEFAULT<\/code>&nbsp;for either parameter, then Oracle Database uses the value defined in the&nbsp;<code>DEFAULT<\/code>&nbsp;profile. By default, all parameters are set to&nbsp;<code>UNLIMITED<\/code>&nbsp;in the&nbsp;<code>DEFAULT<\/code>&nbsp;profile. If you have not changed the default setting of&nbsp;<code>UNLIMITED<\/code>&nbsp;in the&nbsp;<code>DEFAULT<\/code>&nbsp;profile, then the database treats the value for that parameter as&nbsp;<code>UNLIMITED<\/code>.<\/li>\n\n\n\n<li>If you set both of these parameters to&nbsp;<code>UNLIMITED<\/code>, then the database ignores both of them. This is the default if you omit both parameters.<\/li>\n<\/ul>\n\n\n\n<p><strong>PASSWORD_LOCK_TIME<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the number of days an account will be locked after the specified number of consecutive failed login attempts. If you omit this clause, then the default is 1 day.<\/p>\n\n\n\n<p><strong>PASSWORD_GRACE_TIME<\/strong><a><\/a><\/p>\n\n\n\n<p>Specify the number of days after the grace period begins during which a warning is issued and login is allowed. If you omit this clause, then the default is 7 days.<\/p>\n\n\n\n<p id=\"GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3__INACTIVE_ACCOUNT_TIME-585837A4\"><strong>INACTIVE_ACCOUNT_TIME<\/strong><\/p>\n\n\n\n<p>Specify the permitted number of consecutive days of no logins to the user account, after which the account will be locked. The minimum value is 15 days. The maximum value is 24855. If you omit this clause, then the default is&nbsp;<code>UNLIMITED<\/code>.<\/p>\n\n\n\n<p><strong>PASSWORD_VERIFY_FUNCTION<\/strong><a><\/a><a><\/a><\/p>\n\n\n\n<p>You can pass a PL\/SQL password complexity verification script as an argument to&nbsp;<code>CREATE PROFILE<\/code>&nbsp;by specifying&nbsp;<code>PASSWORD_VERIFY_FUNCTION<\/code>. Oracle Database provides a default script, but you can write your own function or use third-party software instead.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For&nbsp;<em><code>function<\/code><\/em>, specify the name of the password complexity verification routine. The function must exist in the&nbsp;<code>SYS<\/code>&nbsp;schema and you must have&nbsp;<code>EXECUTE<\/code>&nbsp;privilege on the function.<\/li>\n\n\n\n<li>Specify&nbsp;<code>NULL<\/code>&nbsp;to indicate that no password verification is performed.<\/li>\n<\/ul>\n\n\n\n<p>If you specify&nbsp;<em><code>expr<\/code><\/em>&nbsp;for any of the password parameters, then the expression can be of any form except scalar subquery expression.<\/p>\n\n\n\n<p><strong>Restriction on Password Parameters<\/strong><\/p>\n\n\n\n<p>When you assign a profile to an external user or a global user, the password parameters do not take effect for that user.<\/p>\n\n\n\n<p>See Also:<\/p>\n\n\n\n<p>&#8220;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/CREATE-PROFILE.html#GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3__I2098662\">Setting Profile Password Limits: Example<\/a>&#8220;<\/p>\n\n\n\n<p><strong>PASSWORD_ROLLOVER_TIME<\/strong><\/p>\n\n\n\n<p>From Oracle 21c onward we can define a gradual password rollover time, which allows us to connect using both the old and the new passwords during the gradual rollover time period. This means we can alter the database user password, and work through any application connections without having a hard cut-off for new connections. This feature was backported to Oracle 19c in the 19.12 release update.<\/p>\n\n\n\n<p>You must configure a non-zero limit for the&nbsp;<code>PASSWORD_ROLLOVER_TIME<\/code>&nbsp;user profile parameter in order to enable the gradual database password rollover. You can configure this parameter using&nbsp;<code>CREATE PROFILE<\/code>&nbsp;or&nbsp;<code>ALTER PROFILE<\/code>.<\/p>\n\n\n\n<p>Use&nbsp;<em><code>expr<\/code><\/em>&nbsp;to specify a value for&nbsp;<code>PASSWORD_ROLLOVER_TIME<\/code>&nbsp;in days. You must specify hours as a fraction of one day. For example, if you want to set the limit to four hours,&nbsp;<em><code>expr<\/code><\/em>&nbsp;would be&nbsp;<code>4\/24<\/code>&nbsp;.<\/p>\n\n\n\n<p>The granularity of the&nbsp;<code>PASSWORD_ROLLOVER_TIME<\/code>&nbsp;limit value is one second. For example, you can have a limit of one hour plus three minutes and five seconds by providing an&nbsp;<em><code>expr<\/code><\/em>&nbsp;like this:&nbsp;<code>( 1\/24) + ( 3\/1440) + (5\/86400) )<\/code>&nbsp;.<\/p>\n\n\n\n<p>The default setting for&nbsp;<code>PASSWORD_ROLLOVER_TIME<\/code>&nbsp;is 0, which means that gradual password rollover is disabled.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Which four account management capabilities can be configured using Oracle profiles? (Choose four.)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A.\u00a0the number of hours for which an account is locked after the configured number of login attempts has been reached<\/li>\n\n\n\n<li><strong>B.\u00a0the number of days for which an account may be inactive before it is locked<\/strong> <strong>INACTIVE_ACCOUNT_TIME<\/strong><\/li>\n\n\n\n<li>C.&nbsp;the maximum amount of CPU time allowed for a user&#8217;s sessions before their account is locked<\/li>\n\n\n\n<li><strong>D.\u00a0the ability to prevent a password from ever being reused<\/strong> <strong>PASSWORD_LIFE_TIME<\/strong><\/li>\n\n\n\n<li><strong>E.\u00a0the number of password changes required within a period of time before a password can be reused PASSWORD_REUSE_TIME<\/strong>\u00a0<strong>and PASSWORD_REUSE_MAX<\/strong><\/li>\n\n\n\n<li><strong>F.\u00a0the number of days for which an account is locked after the configured number of login attempts has been reached<\/strong> <strong>PASSWORD_LOCK_TIME<\/strong><\/li>\n\n\n\n<li>G.&nbsp;the maximum number of sessions permitted for a user before the account is locked<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Profili nam omogo\u010dajo, da reguliramo uporabo sistemskih virov za posameznega uporabnika. Privzeti profil je DEFAULT. Profili so bili uvedeni v verziji 8. Profile za posameznika lahko prika\u017eemo takole: SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS; Lahko pogledamo vse vire za DEFAULT profile SELECT * FROMdba_profilesWHEREPROFILE = &#8216;DEFAULT&#8217;ORDER BYresource_type,resource_name; Link: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/CREATE-PROFILE.html CREATE PROFILE profileLIMIT { resource_parameters| password_parameters}\u2026[&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2023\/10\/01\/profili-profiles\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Profili ( Profiles )<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1299],"tags":[1308],"class_list":["post-11896","post","type-post","status-publish","format-standard","hentry","category-1z0-082","tag-profiles"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=11896"}],"version-history":[{"count":4,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11896\/revisions"}],"predecessor-version":[{"id":11906,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11896\/revisions\/11906"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=11896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=11896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=11896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}