# RE Oracle 9i Role grants not being created

**URL:** <https://forums.toadworld.com/t/re-oracle-9i-role-grants-not-being-created/1490>\
**Category:** Toad Data Modeler\
**Created:** [February 5, 2008, 10:21am UTC](https://forums.toadworld.com/t/re-oracle-9i-role-grants-not-being-created/1490 "2008-02-05T10:21:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![moakes](https://avatars.discourse-cdn.com/v4/letter/m/df705f/32.png) [@moakes](https://forums.toadworld.com/u/moakes)\
**Post date:** [February 5, 2008, 10:21am UTC](https://forums.toadworld.com/t/re-oracle-9i-role-grants-not-being-created/1490/1 "2008-02-05T10:21:49Z")

</div>

Hi,

We have a role (say ROLE\_A) in our Db.  
After RE, the script generated shows;  
CREATE ROLE ROLE\_A;

and;  
GRANT ROLE\_A TO USER1;  
etc

however the grants to the role are not present.  
These are things like;  
GRANT CREATE ANY DIRECTORY TO ROLE\_A;  
(there are a number of these grants).

I can’t see where these would be in TDM, they don’t appear to be stored.

Regards  
Malcolm

---

<div class="post-metadata">

**Author:** ![moakes](https://avatars.discourse-cdn.com/v4/letter/m/df705f/32.png) [@moakes](https://forums.toadworld.com/u/moakes)\
**Post date:** [February 5, 2008, 10:51am UTC](https://forums.toadworld.com/t/re-oracle-9i-role-grants-not-being-created/1490/2 "2008-02-05T10:51:09Z")

</div>

Also,

RE users shows USER\_1 with membership of ROLE\_A.  
However other grants for the user are not present;  
eg  
GRANT UNLIMITED TABLESPACE TO USER\_1

Again I’m not sure where this would be speciified in TDM.

Malcolm

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [February 6, 2008, 4:32am UTC](https://forums.toadworld.com/t/re-oracle-9i-role-grants-not-being-created/1490/3 "2008-02-06T04:32:51Z")

</div>

Hello Malcolm,

This possibility is not in TDM3. We will deal with it. CR # 45 857.

Thanks!

Regards,

Vladka + TDM Team