# COMMAND SET ROLE

**URL:** <https://forums.toadworld.com/t/command-set-role/4401>\
**Category:** SQL Navigator\
**Created:** [February 9, 2011, 7:04am UTC](https://forums.toadworld.com/t/command-set-role/4401 "2011-02-09T07:04:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SGSANTOS](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@SGSANTOS](https://forums.toadworld.com/u/SGSANTOS)\
**Post date:** [February 9, 2011, 7:04am UTC](https://forums.toadworld.com/t/command-set-role/4401/1 "2011-02-09T07:04:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Fsilva](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fsilva/32/39_2.png) [@Fsilva](https://forums.toadworld.com/u/Fsilva)\
**Post date:** [February 9, 2011, 8:37pm UTC](https://forums.toadworld.com/t/command-set-role/4401/2 "2011-02-09T20:37:12Z")

</div>

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

Message was edited by: Fsilva

---

<div class="post-metadata">

**Author:** ![samuel.gsantos\_906](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@samuel.gsantos\_906](https://forums.toadworld.com/u/samuel.gsantos_906)\
**Post date:** [February 11, 2011, 3:32pm UTC](https://forums.toadworld.com/t/command-set-role/4401/3 "2011-02-11T15:32:01Z")

</div>

Yes, it works.

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

Thanks for the feedback.