{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "M9K blog: заметки с тегом OracleSQL",
    "_rss_description": "Заметки обо всём: devops, lifestyle, культура.",
    "_rss_language": "ru",
    "_itunes_email": "",
    "_itunes_categories_xml": "",
    "_itunes_image": "",
    "_itunes_explicit": "",
    "home_page_url": "https:\/\/blog.m9k.space\/tags\/oraclesql\/",
    "feed_url": "https:\/\/blog.m9k.space\/tags\/oraclesql\/json\/",
    "icon": "https:\/\/blog.m9k.space\/user\/userpic@2x.jpg?1769095194",
    "author": {
        "name": "M",
        "url": "https:\/\/blog.m9k.space\/",
        "avatar": "https:\/\/blog.m9k.space\/user\/userpic@2x.jpg?1769095194"
    },
    "items": [
        {
            "id": "146",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-sql-baseenter-audit\/",
            "title": "OracleSQL История неудачных входов пользователя",
            "content_html": "<p>Возникла задача посмотреть историю неудачных входов пользователя за период:<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">SELECT username, terminal, timestamp,returncode  FROM dba_audit_session WHERE username = 'USERNAME' AND RETURNCODE !=0 AND TIMESTAMP between\r\n    to_date('2023-10-20 00:00:00', 'yyyy-mm-dd HH24:MI:SS') and\r\n    to_date('2023-10-20 16:43:00', 'yyyy-mm-dd HH24:MI:SS')<\/code><\/pre>",
            "date_published": "2023-10-20T09:51:19+00:00",
            "date_modified": "2023-10-20T10:12:38+00:00",
            "_date_published_rfc2822": "Fri, 20 Oct 2023 09:51:19 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "146",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "145",
            "url": "https:\/\/blog.m9k.space\/all\/oraclesql-profile-password-lifetime\/",
            "title": "OracleSQL profile password lifetime",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">select * from dba_profiles s where s.profile='PROFILE_NAME' \r\nand resource_name='PASSWORD_LIFE_TIME';<\/code><\/pre>",
            "date_published": "2023-10-20T08:19:53+00:00",
            "date_modified": "2023-10-20T08:19:50+00:00",
            "_date_published_rfc2822": "Fri, 20 Oct 2023 08:19:53 +0000",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "145",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        }
    ],
    "_e2_version": 3877,
    "_e2_ua_string": "E2 (v3877; Aegea)"
}