Page 1 of 1

Profile Option

Posted: Thu May 21, 2009 1:36 pm
by asubramaniam
What is the role for " PROFILE OPTION " in Oracle .Please clear me with some examples .

Posted: Sun May 24, 2009 8:23 am
by siva sankar
Hi,

Profile is an option which will change the way of application running.we can set the profile value at 4 levels 1.user
2.responsiblity
3.application
4.site
5. Server
Site : if we set the profile at site level that will applicable all the users.
Application : If we set the profile value as application it will applicable to the user who r having access to that specific application.if user is having both access to site and application level .application will overwrite site level.
Responsiblity : If we set the profile value as responsiblity that will applicable to the users who r having access to the specific responsiblity.if user having access to site application responsiblity.then responsiblity will overwrite the site application.
User : User is top most level.if we set profile value as user.if user having access to site application responsibility user.then user will overwirte site applcation responsibility.

Thanks & Regards,

Siva

Posted: Tue May 26, 2009 3:54 am
by asubramaniam
Excellent Mr Siva, You made me clear.. thank yu very much.