Voltar
-
Título
Problem in granting roles -
Descrição
There is a problem in granting roles. After double clicking a table on the object palette window, it generates the DDL, but the GRANT statement is wrong about ROLE. TOAD generates the GRANT as follows:
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO USER ROLE_USR;
But "ROLE_USR" is a ROLE not USER
The right statement should be
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO ROLE ROLE_USR;
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.