Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename a profile in Oracle

853126Sep 12 2011 — edited Sep 13 2011

Hi..

I had one question.. Can we rename a profile in Oracle and if yes can you please let me know how do we do it??.

Eg: I have a profile as follows:

CREATE PROFILE my_profile LIMIT
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME 15
CONNECT_TIME DEFAULT
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 6
PASSWORD_LIFE_TIME 90
PASSWORD_REUSE_TIME 4
PASSWORD_REUSE_MAX 4
PASSWORD_VERIFY_FUNCTION PASSWORD_COMPLEXITY_FUNCTION
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME 15
/

I want to rename this profile to END_USER.

Please let me know the steps.

Thanks
Ravikanth Garimella

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2011

Added on Sep 12 2011

#general-database-discussions

3 comments

2,676 views