Re: How to determine when a particular schema was created within a database.

Hi,


Select on dba_users should give you enough details that you are looking
for??


 SQL>
SQL>
SQL> desc dba_users;
 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)
 ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
 CREATED                                   NOT NULL DATE
 PROFILE                                   NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
 EXTERNAL_NAME                                      VARCHAR2(4000)
 PASSWORD_VERSIONS                                  VARCHAR2(8)
 EDITIONS_ENABLED                                   VARCHAR2(1)
 AUTHENTICATION_TYPE                                VARCHAR2(8)
SQL> select USERNAME,CREATED  from dba_users where USERNAME='XXXXX';
USERNAME                       CREATED
------------------------------ ---------
XXXXX                             05-OCT-10
SQL>


Thanks,
Gidhin

On 18 October 2010 23:16, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:

> If you have audit_sys_operations set to true, and you haven't deleted the
> old information, the create date of the user should be available in the
> audit files.
>
>
> On Mon, Oct 18, 2010 at 12:36 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
>
>>  What Brandon posted is probably the best you can do, at least without
>> some sort of audit trail, which, if you’re asking the question after the
>> fact, is probably not available.
>>
>>
>>
>> However, it’s really not sufficient.
>>
>>
>>
>> I could create object A today, object B tomorrow, and drop object A the
>> day after tomorrow.  Then, Brandon’s query will return yesterday’s date,
>> rather than the day before yesterday.
>>
>>
>>
>> There’s no good, obvious way around this, that I can see.  I’m just
>> pointing out a possible weakness in the strategy.
>>
>>
>>
>> -Mark
>>
>>
>>
>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Allen, Brandon
>>
>> *Sent:* Monday, October 18, 2010 1:27 PM
>> *To:* murrays@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>> *Subject:* RE: How to determine when a particular schema was created
>> within a database.
>>
>>
>>
>> Try this:
>>
>>
>>
>> select min(created) from dba_objects where owner = ‘<SCHEMA_OWNER>’;
>>
>>
>>
>> Regards,
>>
>> Brandon
>>
>>
>>  ------------------------------
>>
>> Privileged/Confidential Information may be contained in this message or
>> attachments hereto. Please advise immediately if you or your employer do not
>> consent to Internet email for messages of this kind. Opinions, conclusions
>> and other information in this message that do not relate to the official
>> business of this company shall be understood as neither given nor endorsed
>> by it.
>>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

Other related posts: