Home » RDBMS Server » Security » Alter profile (Oracle 11gr2,Linux)
Alter profile [message #580542] Mon, 25 March 2013 13:40 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Alter profile [message #580544 is a reply to message #580543] Mon, 25 March 2013 14:09 Go to previous messageGo to next message
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,
Re: Alter profile [message #580546 is a reply to message #580544] Mon, 25 March 2013 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And in your opinion, what could be the impact?

Regards
Michel
Re: Alter profile [message #580549 is a reply to message #580546] Mon, 25 March 2013 14:57 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
No idea Michel. That is why i am asking you the questions.
Re: Alter profile [message #580550 is a reply to message #580549] Mon, 25 March 2013 15:05 Go to previous messageGo to next message
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,
Re: Alter profile [message #580587 is a reply to message #580550] Tue, 26 March 2013 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Alter profile [message #580763 is a reply to message #580587] Wed, 27 March 2013 15:06 Go to previous messageGo to next message
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,
Re: Alter profile [message #580768 is a reply to message #580763] Wed, 27 March 2013 17:41 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you read the docuementation page on create_profile?
Re: Alter profile [message #580770 is a reply to message #580768] Wed, 27 March 2013 18:53 Go to previous messageGo to next message
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.
Re: Alter profile [message #580778 is a reply to message #580763] Thu, 28 March 2013 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Alter profile [message #580827 is a reply to message #580778] Thu, 28 March 2013 08:06 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
Please DO search on the documentation BEFORE posting a question.


Ok Michel
Previous Topic: Keep secure customer data.
Next Topic: Patch official document link
Goto Forum:
  


Current Time: Thu Mar 28 18:12:21 CDT 2024