Home » RDBMS Server » Server Administration » ProfileCreatedDate
ProfileCreatedDate [message #200010] Fri, 27 October 2006 07:05 Go to next message
Messages: 41
Registered: August 2006
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...

Re: ProfileCreatedDate [message #200227 is a reply to message #200010] Sun, 29 October 2006 14:37 Go to previous message
Frank Naude
Messages: 4509
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)
Previous Topic: How to Qualify the Application on Oracle10g
Next Topic: Net configuration files
Goto Forum:

Current Time: Fri Jul 21 17:48:16 CDT 2017

Total time taken to generate the page: 0.25313 seconds