Re: How to determine when a particular schema was created within a database.
- From: "gidhin K. joy" <gidhin@xxxxxxxxx>
- To: "murrays@xxxxxxxxxxxxxxxxxxxx" <murrays@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Oct 2010 15:12:28 +0530
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:
