Toad World® Forums

RE Oracle 9i Role grants not being created


#1

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


#2

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


#3

Hello Malcolm,

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

Thanks!

Regards,

Vladka + TDM Team