bbd PS8

1.
CONNECT system/czemunie
SELECT USERNAME,PROFILE FROM DBA_USERS;
SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT';
2.
CREATE PROFILE PROF_rosinski LIMIT
    PASSWORD_LIFE_TIME 1
    FAILED_LOGIN_ATTEMPTS 2
    PASSWORD_LOCK_TIME  0.42    -- ewneutalnie wpisac 1/24
    PASSWORD_GRACE_TIME 1
    CONNECT_TIME 30
3.
ALTER USER Rosinski PROFILE PROF_rosinski;
4.
CONNECT Rosinski/zlehaslo;
CONNECT Rosinski/zlehaslo1;
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='Rosinski';
5.
Uzytkownik Rosinski bedzie mogl po godzinie zalogowac sie na swoje konto. -- WARTOSCI Z TABEL SLOWNIKOWYCH
6.
Po jednym dniu haslo uzytkownika wygasnie. -- samemu znalezc sposob
SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE FROM USER_USERS
7.
ALTER PROFILE PROF_rosinski LIMIT
    PASSWORD_LIFE_TIME 7;
8.
CREATE PROFILE profilek LIMIT
    SESSIONS_PER_USER 1
    IDLE_TIME 3;
SELECT * FROM DBA_PROFILES;
9.
ALTER USER BBD1 PROFILE profilek;
10.
??? 3 minuty afk kurwa idz DO sracza....
11.
-- nie jestem pewien co do REFUSE MAX  I TIME
ALTER PROFILE profilek LIMIT
        FAILED_LOGIN_ATTEMPTS 1
        PASSWORD_REUSE_TIME 0
        PASSWORD_REUSE_MAX 1;
12.
NO PIZDE SOBIE ZWERYFIKUJ
13.
ALTER PROFILE profilek LIMIT
    CPU_PER_CALL 1;
14.
SELECT * FROM DBA_PROFILES;

--
--select * from user_resource_limits a
--where a.resource_name in ('IDLE_TIME','CONNECT_TIME');