1.
select * from inf59859.pracownicy@lab92;
2.
grant select on pracownicy to inf59852;
4.
grant update(placa_pod, placa_dod) on pracownicy to inf59852;

update inf59852.pracownicy 
set placa_pod= 666 where id_prac=100;

create synonym sielba for inf59852.pracownicy;

5.
update sielba
set placa_dod=4321 where id_prac = 120;

6.
select * from user_role_privs;

select * from user_tab_privs_made;

select * from user_tab_privs_recd;

7.
revoke update on pracownicy from inf59852;

8.
create role pipa identified by skos;
grant select, update on pracownicy to pipa;
grant pipa to inf59852;
set role zzz identified by seba;
update sielba
set nazwisko='sielecki';

11.
revoke pipa from inf59852;

revoke select on pracownicy from inf59852;


grant select on pracownicy to inf59852 with grant option;


15.
revoke select on pracownicy from inf59852;


create or replace view prac20aaa as
select nazwisko,placa_pod from pracownicy where id_zesp=20;