SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 74

REVOKE UPDATE
ON emp_test
FROM hr_emps;
Lastly, there is one more thing just like role, its called profile.
Profiles allow you to assign resource consumption limit or
setting password policies on user accounts. All user accounts
have profile assigned to them. If you don't assign it explicitly
while creating or altering the user account explicitly, a default
one gets assigned automatically.
You can assign profile to a user account at the time of creation of
account or you can use ALTER USER command to assign it
later. Let's have a look on the following example.
Example:
CREATE USER marion
IDENTIFIED mateena
PROFILE paramod;
Or,
ALTER USER marion
PROFILE paramod;
Here mateena is a password for username marion and paramod is
the name of a profile we created earlier, it could be any name.
Now let's see how we can create profile.
Example:
CREATE PROFILE paramod
LIMIT CONNECT_TIME UNLIMITED;
Or,
ALTER PROFILE sidney
LIMIT CONNECT_TIME 240;