Date: Fri, 29 Mar 2024 12:28:21 +0300 (MSK) Message-ID: <944447632.21085.1711704501084@localhost> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_21084_149953205.1711704501083" ------=_Part_21084_149953205.1711704501083 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
1. =D0= =92 =D0=BA=D0=BE=D0=BC=D0=B0=D0=BD=D0=B4=D0=BD=D0=BE=D0=B9 =D1=81=D1=82=D1= =80=D0=BE=D0=BA=D0=B5: sqlplus system/manager@ORCL create user <=D0=B8=D0=BC=D1=8F> identified by <=D0=BF=D0=B0=D1=80= =D0=BE=D0=BB=D1=8C>; grant connect, resource to <=D0=B8=D0=BC=D1=8F>; 2. =D0=92 PL/SQL Developer =D1=81=D0=BE=D0=B5=D0=B4=D0=B8=D0=BD=D0=B8=D1=82= =D1=8C=D1=81=D1=8F =D0=BF=D0=BE=D0=B4 <=D0=B8=D0=BC=D1=8F> <=D0=BF= =D0=B0=D1=80=D0=BE=D0=BB=D1=8C> ORCL Create table USERS (user_id INTEGER, login VARCHAR2(100), email VARCHAR2(3= 00), name VARCHAR2(300), password_hash VARCHAR2(100)); 3. =D0=9D=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D1=82=D1=8C =D0=A5=D0=9F =D0=B4=D0= =BB=D1=8F =D1=80=D0=B5=D0=B3=D0=B8=D1=81=D1=82=D1=80=D0=B0=D1=86=D0=B8=D0= =B8 =D0=BD=D0=BE=D0=B2=D0=BE=D0=B3=D0=BE =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0= =BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8F =D1=81 =D0=B7=D0=B0=D0=B4=D0=B0=D0= =BD=D0=BD=D1=8B=D0=BC =D0=BB=D0=BE=D0=B3=D0=B8=D0=BD=D0=BE=D0=BC, =D0=BF=D0= =B0=D1=80=D0=BE=D0=BB=D0=B5=D0=BC, email =D0=B8 =D0=B8=D0=BC=D0=B5=D0=BD=D0= =B5=D0=BC. =D0=9F=D1=80=D0=BE=D0=B2=D0=B5=D1=80=D0=B8=D1=82=D1=8C =D1=83=D0=BD=D0=B8= =D0=BA=D0=B0=D0=BB=D1=8C=D0=BD=D0=BE=D1=81=D1=82=D1=8C =D0=BB=D0=BE=D0=B3= =D0=B8=D0=BD=D0=B0 =D0=B8 email. =D0=95=D1=81=D0=BB=D0=B8 login =D0=BD=D0= =B5 =D0=B7=D0=B0=D0=B4=D0=B0=D0=BD, =D0=B8=D1=81=D0=BF=D0=BE=D0=BB=D1=8C=D0= =B7=D0=BE=D0=B2=D0=B0=D1=82=D1=8C =D0=B2 =D0=B5=D0=B3=D0=BE =D0=BA=D0=B0=D1= =87=D0=B5=D1=81=D1=82=D0=B2=D0=B5 email. =D0=9F=D0=B0=D1=80=D0=BE=D0=BB=D1=8C =D0=BF=D0=B5=D1=80=D0=B5=D0=B4=D0=B0= =D0=B5=D1=82=D1=81=D1=8F =D0=B2 =D0=BE=D1=82=D0=BA=D1=80=D1=8B=D1=82=D0=BE= =D0=BC =D0=B2=D0=B8=D0=B4=D0=B5, =D0=BD=D0=BE =D1=85=D1=80=D0=B0=D0=BD=D0= =B8=D1=82=D1=81=D1=8F =D0=B2 =D0=B2=D0=B8=D0=B4=D0=B5 =D1=85=D1=8D=D1=88=D0= =B0: =09DBMS_CRYPTO.Hash ( UTL_I18N.STRING_TO_RAW ('password', 'AL32UTF8'), 2) 4. =D0=9D=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D1=82=D1=8C =D0=A5=D0=9F =D0=B4=D0= =BB=D1=8F =D0=BB=D0=BE=D0=B3=D0=B8=D0=BD=D0=B0 =D0=BF=D0=BE=D0=BB=D1=8C=D0= =B7=D0=BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8F USER_LOGIN(p_login, p_passwor= d) =D0=BA=D0=BE=D1=82=D0=BE=D1=80=D0=B0=D1=8F =D0=BF=D1=80=D0=BE=D0=B2=D0= =B5=D1=80=D1=8F=D0=B5=D1=82 =D0=BD=D0=B0=D0=BB=D0=B8=D1=87=D0=B8=D0=B5 =D0= =BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8F =D0= =B8 =D0=BF=D1=80=D0=B0=D0=B2=D0=B8=D0=BB=D1=8C=D0=BD=D0=BE=D1=81=D1=82=D1= =8C =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D1=8F.