Re: DBA_FEATURE_USAGE_STATISTICS and ASO
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: jim@xxxxxxxxxxxxxxxxxxx
- Date: Tue, 26 Jan 2010 14:09:02 +0000
In 11g the likely task is BSLN_MAINTAIN_STATS_JOB,
thanks for the feedback - that makes sense here - and thanks for the
company name in the signature, that just makes me smile.
Niall
On Tue, Jan 26, 2010 at 1:08 PM, Jim Smith <jim@xxxxxxxxxxxxxxxxxxx> wrote:
> In message <7765c8971001250622w6456218bs62ad20c5a6ecb25@xxxxxxxxxxxxxx>,
> Niall Litchfield <niall.litchfield@xxxxxxxxx> writes
>
> Hi all
>>
>> Does anyone know how DBA_FEATURE_USAGE_STATISTICS is populated? I'm
>> prepared for the "of course not because then people could circumvent
>> the tests" answer. In particular I'm interested in how Advanced
>> Security (the licensable option) is detected since it appears from my
>> tests that creating external users using windows authentication (CREATE
>> USER "OPS$DOMAIN\USERNAME" IDENTIFIED EXTERNALLY;) will trigger the
>> detection of ASO.
>>
>
> I looked into this a while ago. IIRC, local windows accounts don't trigger
> it, but domain accounts do. It seems to count as GLOBAL authentication.
>
> There is a process which runs once a week or so which populates DFUS. I
> couldn't find out what it was so I had to wait a week between every stage of
> my testing. Needless to say I didn't take it very far.
> --
> Jim Smith
> Ponder Stibbons Limited
> 251 Barcombe Avenue
> London SW2 3BH
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts: