Home » RDBMS Server » Server Administration » PROFILE CREATION DATE (Oracle 11.2.0.3 / OEL 5)
PROFILE CREATION DATE [message #577363] Thu, 14 February 2013 08:24 Go to next message
jesuisantony
Messages: 112
Registered: July 2006
Location: Chennai
Senior Member
Hi All,

Is there a way to find when was a database role created and who has created?

Regards,
Antony
Re: PROFILE CREATION DATE [message #577364 is a reply to message #577363] Thu, 14 February 2013 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless you use Log Miner.

Regards
Michel
Re: PROFILE CREATION DATE [message #577373 is a reply to message #577364] Thu, 14 February 2013 11:22 Go to previous messageGo to next message
xtender
Messages: 33
Registered: January 2011
Location: Russia
Member

You can get from data dictionary only role creation time:
SQL> create role test_role;

Role created.

Elapsed: 00:00:00.42
SQL> select name,ctime
  2  from sys.user$
  3  where name='TEST_ROLE';

NAME                           CTIME
------------------------------ -------------------
TEST_ROLE                      2013-02-14 18:18:51

1 row selected.
Re: PROFILE CREATION DATE [message #577380 is a reply to message #577373] Thu, 14 February 2013 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Gee! I answered the title question and not the post one!

Regards
Michel
Re: PROFILE CREATION DATE [message #577405 is a reply to message #577363] Thu, 14 February 2013 19:56 Go to previous messageGo to next message
jesuisantony
Messages: 112
Registered: July 2006
Location: Chennai
Senior Member
oops.. sorry ..it was my mistake.... I was looking for the profile creation details only. Anyways the information about role was also useful for me ....
Re: PROFILE CREATION DATE [message #577408 is a reply to message #577405] Fri, 15 February 2013 00:55 Go to previous message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, for the profile, there is nothing in the dictionary.

Regards
Michel
Previous Topic: Unable to find the server process in the oracle database for a specific application/client
Next Topic: nls_database_parameters vs nls_instance_parameters
Goto Forum:
  


Current Time: Fri Apr 18 01:33:52 CDT 2014

Total time taken to generate the page: 0.14983 seconds