Toad World® Forums

COMMAND SET ROLE


#1

Hello everybody,

I am new to this forum. I wonder if anyone has gone through this problem. In the version of SQL Navigator 6.1 I can not perform this command:

SET ROLE OPERADOR_TESTE IDENTIFIED BY ‘test’;

Soon after making the following command:

select * from test;

Note: My system uses the SET ROLE command to apply the roll and then allow access to the tables of the database.

Now appreciate the support.

Thanks.

Message was edited by: SGSANTOS


#2

What error do you get?
does it work with sql plus ?

Message was edited by: Fsilva


#3

Yes, it works.

I solved the problem by applying a patch, coming to version 6.4.

Thanks for the feedback.