Skip to Main Content


Question and Answer

Chris Saxon

Thanks for the question, Renee.

Asked: February 13, 2020 - 4:04 am UTC

Answered by: Chris Saxon - Last updated: February 13, 2020 - 10:51 am UTC

Category: Database Administration - Version: 12.1

Viewed 100+ times

You Asked

Is it true that roles can not be granted to other roles anymore? I am unable to find documentation of this, but was informed that this was taken away in 12c. If this is true, will you please post the document?

and we said...

You need to ask whoever told you that to prove it.

A simple counter example shows you can still do this in 19.3:

create role r1;
create role r2;

grant create session to r1;
grant r1 to r2;
grant r2 to u identified by u;

conn u/u

select * from dual;


More to Explore


New to good database design? Check out Chris Saxon's full fundamentals class.