Re: Oracle 10.2.0.4.0

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 7 Jan 2011 19:52:00 +0530
Message-ID: <AANLkTik08WZNUZAju2fy-O5BvF-BpB-XBSTia7bOXLwU_at_mail.gmail.com>

I think the answer is absolutely right..casue it depends on installation and components choosed while installing

role is nothing but collection of certain privileges(object privs, database privs and system privs are different), and this is why if suppose I am not installing some componnent( like xdb, odm, ultra search etc), then that componenet related privileges and some default roles will not be present in that database
conn as sys and fire the below like query

select tname from tab where tname like '%ROLE%' you may get what you are looking for..:)

thanks..subodh
On 7 January 2011 19:20, Thomas Day <tomdaytwo_at_gmail.com> wrote:

> What are the roles that come "out of the box" when you first install
> 10.2.0.4.0. I've tried searching Oracle's documentation but I just haven't
> hit the magic phrase.
> http://psoug.org/reference/roles.html has a nice list but I'd like to see
> it direct from Oracle's mouth.
>
> I've been told that
>
> "Oracle Standard Roles ( created by oracle)
>
> LBAC_DBA
>
> XDBWEBSERVICES "
>
>
> The PSOUG link has XDB_WEBSERVICES. It doesn't have anything like
> LBAC_DBA. The XDBWEBSERVICES role varies in its privileges from instance
> to instance in the installation that I'm looking at.
>
>
> If someone could point me to an authoritative list from oracle.com I'd be
> grateful.
>
>
> Thanks
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 07 2011 - 08:22:00 CST