Notes

1-Criar users: create user func_Jalmeida identified by funcionario
2-Criar roles: create role;
3-Associar roles: grant role_aluno to csousa;
3-Associar roles a roles: grant connect to role aluno;
4- Verificar operações anteriores: Select username from DBA_USERS where UPPER(username)= 'CSOUSA';
Select * From dba_role_privs;
Select * From role_role_privs;
5- Privilégios de cada utilizador: Select * From dba_sys_privs;
Select * Ffrom dba

6-

CREATE OR REPLACE FUNCTION my_verification_function (
username VARCHAR2,
password VARCHAR2,
old_password VARCHAR2) RETURN BOOLEAN AS
BEGIN
IF LENGTH(password) < 6 THEN RETURN FALSE;
ELSIF(password = 'password' OR password ='123' OR password = old_password)
THEN RETURN FALSE;
ELSE RETURN TRUE;
END IF;
END my_verification_function;

7-
create profile perfil_aluno limit
failed_login_attempts 3
password_reuse_max 5
password_verify_function my_verification_function
PASSWORD_LOCK_TIME 15/24/60
password_life_time 60
password_reuse_time 30
password_grace_time 10;

8-
ALTER user NOME
PROFILE perfil_aluno;

9-
conn fsilva/123
ALTER user fsilva
identified by password
replace 123;

10-

create profile perfil_funcionario limit
sessions_per_user 2
cpu_per_session unlimited
cpu_per_call 30*100
connect_time 45
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 15k;

11

12-
alter table aluno
add username varchar2(20);
alter table inscricao
add(meiopagamento varchar2(10) constraint cv_inscricao_meiopag CHECK (UPPER(meioPagamento) IN ('DINHEIRO', 'CHEQUE', 'CARTAO'),
NUMCARTAOCREDITO varchar2(20) );

13-
Update Aluno set Username = 'csousa' WHERE bi=10700007;
'scosta' WHERE bi=10700007;
'fsilva' WHERE bi=10700007;
udate inscricao set meiopagamento = 'dinheiro' where codInscricao = 7089;