What is a profile ?

Each database user is assigned a Profile that specifies limitations on various system resources available to the user.

Interview Candidate
Sep 6th, 2004
6
2755

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

Chiranjeevi Manne

Mar 30th, 2007

A profile contains the details about the RESOURCE LIMITS and PASSWORD LIMITS at Oracle level pertaining to a specific user.

gbansal4
Profile Answers by gbansal4 Questions by gbansal4

Dec 15th, 2007

A profile is used to restrict the reource uses, password reuses, idle time of a session etc. We can also attach a password verify function for the database user. A database user can be assigned a profile. It is an optional clause. By default it takes DEFAULT profile.