OraFAQ Forum: Server Administration » How to check the last modification date of the resource

Home » RDBMS Server » Server Administration » How to check the last modification date of the resource_name in profile (SUSE-LINUX)

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

How to check the last modification date of the resource_name in profile [message #442669]

Tue, 09 February 2010 19:48

*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.

Report message to a moderator

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

ramoradba
Messages: 2457
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

Report message to a moderator

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

Blaylock
Messages: 6
Registered: February 2010
Location: USA

Junior Member

Yeah i am agree with ramoradba.

Report message to a moderator

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

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

It shows the error - 00904: "SCN_TO_TIMEFRAME" invalid identifier.

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:23:52 CST 2024