Re: Oracle 10.2.0.4.0
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: tomdaytwo@xxxxxxxxx
- Date: Fri, 7 Jan 2011 19:52:00 +0530
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@xxxxxxxxx> 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
==============================
Other related posts:
