 
create table AutorizaMatrTF
(
    CodigoEmp      char(2)         not null,
    Matricula      char(15)        not null,
    Funcao         char(8)         not null,
    Descricao      char(30)        not null,
    DataAtual      datetime        not null,
    MatrAtual      char(15)        not null
);
 
alter table AutorizaMatrTF
    add constraint pk_AutorizaMatrTF primary key (CodigoEmp, Matricula, Funcao);
 
create index AutorizaMatrTF_FK1 on AutorizaMatrTF (CodigoEmp, Matricula);
 
GRANT ALL ON AutorizaMatrTF TO BYTEC;

create table PermissaoTF
(
    CodigoEmp      char(2)         not null,
    Matricula      char(15)        not null,
    DataAtual      datetime        not null,
    MatrAtual      char(15)        not null
);
  
alter table PermissaoTF
    add constraint pk_PermissaoTF primary key (CodigoEmp, Matricula);

create index PermissaoTF_FK1 on PermissaoTF (Matricula, CodigoEmp); 
 
GRANT ALL ON PermissaoTF TO BYTEC;
 
insert into PERMISSAOTF values 
( '01', 'ERPF           ', GETDATE(), 'ERPF           ' );
commit;