-- Criação de usuários
--create user dbausernew with password 'no ron';
--create user medicousernew with password 'no ron';
--create user estagiariousernew with password 'no ron';
--create user secretariousernew with password 'no ron';

-- Poder de Luta do Estagiário
grant select(nome) on Paciente to estagiariousernew;
grant select(nome) on Medico to estagiariousernew;
grant select(data) on Consulta to estagiariousernew;

-- Poder de Luta do Médico
grant all on paciente to medicousernew;

-- Poder de Luta do DBA

grant select(salario), update(salario) on funcionario to dbausernew;

-- Poder de Luta da Secretaria

--create view secretarioview as
--select * from medico where numeroa=4;

grant select on secretarioview to secretariousernew;