Who owns a role?

[JOHNZ]

In OCP test, there is a question, who owns a role?
a)sys
b)system
c)dba
e)user
f)grantee
g)grantor
h)no one
What is the correct answer, Please help OCP!
This question has been repeatedly ocurred in the DBA test.

[Edited by johnz on 02-24-2001 at 01:44 AM]

[rohitsn]

Hi,
This is Rohit from India.I am an OCP.As per ur question in Oracle no one owns a role.When u create a role no one is the owner of the role.If u have any doubts please write to me at
rohitsn@hotmail.com

[Sharma]

I agree with Rohit, No one owns the Role.

If I don't have a choice to answer "NO ONE OWNS THE ROLE", I will prefer to use Creator of the role. Bacause, If I create the role, no one else can grant it except SYS.

[mnicoras]

Hi Sharma,

I must agree with Rohit. I have just all exams for OCP 8.0 DBA and one of my question was exaclty this one but I have the answer nobody between all the others. At the end for the questions from Role Subject I have get 3 of 3. So!

Best Regards,
Marius

[Orabee]

Hi,
I just took a quick look at Oracle 8 Admin TBT materials ...it specifically points out that one of the characteristics a role is that it's not owned by anyone and it's not in any schema.

[kateko]

mnicoras
Have you taken the database administration test for oracle 8?

[JOHNZ]

Thanks everybody for the answer. I forget the one that is the answer. I think no one owes a role.
By the Way, in my test: if A create a role B with Admin option
B created a role C. If A drop B cascade, will the role be dropped. I made the mistake in this question after reviewing your answers above. The role will remain, am I right? Thanks for your anwer.

[opsdba]

No one owns roles in the database
Answer is (h)