Profiles

[Paul H]

Plse can anyone help, how do I remove a profile setting from a user (oracle 8.1.7)??


I have created the profile with "alter user scott profile profile_name"

can the profile be removed with another "alter user"
or does the profile have to be dropped completeley??


many thanx in advance

[marek_wiechula]

A user must have a profile. If you don't want to assign him one based on specific criteria then you assign him the DEFAULT profile.

ALTER USER PROFILE DEFAULT ;