Home » RDBMS Server » Server Administration » How to check the last modification date of the resource_name in profile (SUSE-LINUX)
How to check the last modification date of the resource_name in profile [message #442669] Tue, 09 February 2010 19:48 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Hi, we have a few profiles in dba_profile. How to check what is the last modification date of the the resources inside each profile.

Thanks in advance.
Re: How to check the last modification date of the resource_name in profile [message #442673 is a reply to message #442669] Tue, 09 February 2010 21:55 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
There is no such column for this...
We need to audit the privilege who can change the profile.

Sriram Smile
Re: How to check the last modification date of the resource_name in profile [message #443000 is a reply to message #442669] Thu, 11 February 2010 23:52 Go to previous messageGo to next message
Blaylock
Messages: 6
Registered: February 2010
Location: USA
Junior Member
Yeah i am agree with ramoradba.
Re: How to check the last modification date of the resource_name in profile [message #443143 is a reply to message #443000] Sat, 13 February 2010 00:35 Go to previous messageGo to next message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
If changes are made recently, See if this works

select
n.name, m.name,scn_to_timestamp(u.ora_rowscn)
from sys.profile$ u, sys.profname$ n, sys.resource_map m
where u.resource# = m.resource#
and u.type#=m.type#
and n.profile# = u.profile#

[Updated on: Sat, 13 February 2010 00:57]

Report message to a moderator

Re: How to check the last modification date of the resource_name in profile [message #443161 is a reply to message #443143] Sat, 13 February 2010 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This gives you the last modification of your profile... or another profile in the same block.
Not really reliable.

Regards
Michel
Re: How to check the last modification date of the resource_name in profile [message #471606 is a reply to message #443161] Mon, 16 August 2010 05:15 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi,

It shows the error - 00904: "SCN_TO_TIMEFRAME" invalid identifier.
Re: How to check the last modification date of the resource_name in profile [message #471610 is a reply to message #471606] Mon, 16 August 2010 05:27 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ What has this to do with the previous question?
2/ Do NOT hijack another topic for your question, create a new one
3/
Quote:
00904: "SCN_TO_TIMEFRAME" invalid identifier.

Maybe you should learn to read.

Regards
Michel
Previous Topic: TNS error, DBCA after database creation script complete
Next Topic: sizing undo tablespace & setting Undo_retenion
Goto Forum:
  


Current Time: Wed Dec 07 18:26:21 CST 2016

Total time taken to generate the page: 0.17459 seconds