OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ProfileCreatedDate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ProfileCreatedDate [message #200010]

Fri, 27 October 2006 07:05

thiyagaraj
Messages: 41
Registered: August 2006

Member

Hi
I want to know the date in which my profile has been created.
I have created a profile "A" in my DB,now i want to know when it was created.
Are profiles also objects like table,views...

Thanks
-Raaj

Report message to a moderator

Re: ProfileCreatedDate [message #200227 is a reply to message #200010]

Sun, 29 October 2006 14:37

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Oracle doesn't store profile creation date:

SQL> desc profile$
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PROFILE#                                  NOT NULL NUMBER
 RESOURCE#                                 NOT NULL NUMBER
 TYPE#                                     NOT NULL NUMBER
 LIMIT#                                    NOT NULL NUMBER

SQL> desc dba_profiles;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PROFILE                                   NOT NULL VARCHAR2(30)
 RESOURCE_NAME                             NOT NULL VARCHAR2(32)
 RESOURCE_TYPE                                      VARCHAR2(8)
 LIMIT                                              VARCHAR2(40)

Report message to a moderator

Previous Topic:	How to Qualify the Application on Oracle10g
Next Topic:	Net configuration files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:39:51 CDT 2024