OraFAQ Forum: Security » Alter profile

Home » RDBMS Server » Security » Alter profile (Oracle 11gr2,Linux)

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

Alter profile [message #580542]

Mon, 25 March 2013 13:40

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I have one question on changing resource limit to unlimited.

Would there be any impact to database and application when we change the limit PASSWORD_LIFE_TIME to UNLIMITED
for app users having some profile named 'NEW_PROFILE' as default ?

Regards,
Jack

[Updated on: Mon, 25 March 2013 13:44]

Report message to a moderator

Re: Alter profile [message #580543 is a reply to message #580542]

Mon, 25 March 2013 13:54

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

Senior Member
Account Moderator

Yes there would be:
1/ Any change has an impact
2/ Think a little bit what is the purpose of this parameter

Regards
Michel

Report message to a moderator

Re: Alter profile [message #580544 is a reply to message #580543]

Mon, 25 March 2013 14:09

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

MIchel,

Quote:

Any change has an impact

I mean would there be major impact to database and application like database /application will be down something like that ..
I know due to this change , the user password will not get expired forever.Not sure of the impact on application.

Regards,

Report message to a moderator

Re: Alter profile [message #580546 is a reply to message #580544]

Mon, 25 March 2013 14:46

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

Senior Member
Account Moderator

And in your opinion, what could be the impact?

Regards
Michel

Report message to a moderator

Re: Alter profile [message #580549 is a reply to message #580546]

Mon, 25 March 2013 14:57

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

No idea Michel. That is why i am asking you the questions.

Report message to a moderator

Re: Alter profile [message #580550 is a reply to message #580549]

Mon, 25 March 2013 15:05

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

For the above profile ,idle time is set to 'DEFAULT' limit. Could you tell me what is the inactive time
a session can be idle ?

Regards,

Report message to a moderator

Re: Alter profile [message #580587 is a reply to message #580550]

Tue, 26 March 2013 01:23

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

Senior Member
Account Moderator

Maybe you should FIRST read the documentation, then think a little bit and then post questions.
Your question is DIRECTLY answered in the documentation. It is simply the definition of the value DEFAULT.

Regards
Michel

Report message to a moderator

Re: Alter profile [message #580763 is a reply to message #580587]

Wed, 27 March 2013 15:06

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel,

Can you provide me the documentation link here for the answer i am looking for .I couldn't find it out in oracle documentation.

SQL> select * from dba_profiles where profile ='DSS_PROFILE' and resource_name = 'IDLE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DSS_PROFILE                     IDLE_TIME                       KERNEL   DEFAULT

Here i want to know the default value of IDLE_TIME for a session for a user been assigned a default profile in Oracle 11g.

Regards,

Report message to a moderator

Re: Alter profile [message #580768 is a reply to message #580763]

Wed, 27 March 2013 17:41

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you read the docuementation page on create_profile?

Report message to a moderator

Re: Alter profile [message #580770 is a reply to message #580768]

Wed, 27 March 2013 18:53

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you Cookiemaster for the hints. Smile

Quote:

UNLIMITED

When specified with a resource parameter, UNLIMITED indicates that a user assigned this profile can use an unlimited amount of this resource. When specified with a password parameter, UNLIMITED indicates that no limit has been set for the parameter.

DEFAULT

Specify DEFAULT if you want to omit a limit for this resource in this profile. A user assigned this profile is subject to the limit for this resource specified in the DEFAULT profile. The DEFAULT profile initially defines unlimited resources. You can change those limits with the ALTER PROFILE statement.

Any user who is not explicitly assigned a profile is subject to the limits defined in the DEFAULT profile. Also, if the profile that is explicitly assigned to a user omits limits for some resources or specifies DEFAULT for some limits, then the user is subject to the limits on those resources defined by the DEFAULT profile.

Report message to a moderator

Re: Alter profile [message #580778 is a reply to message #580763]

Thu, 28 March 2013 01:30

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

Senior Member
Account Moderator

Quote:

an you provide me the documentation link here for the answer i am looking for

This is ALWAYS the same link we provided you in your more than 100 topics.
Please DO search on the documentation BEFORE posting a question.

Regards
Michel

Report message to a moderator

Re: Alter profile [message #580827 is a reply to message #580778]

Thu, 28 March 2013 08:06

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

Please DO search on the documentation BEFORE posting a question.

Ok Michel

Report message to a moderator

Previous Topic:	Keep secure customer data.
Next Topic:	Patch official document link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 14:00:52 CDT 2025