Profile Option

[asubramaniam]

What is the role for " PROFILE OPTION " in Oracle .Please clear me with some examples .

[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

[asubramaniam]

Excellent Mr Siva, You made me clear.. thank yu very much.