User Profile

[Fiza15]

Hi all
I am trying to find out where user profiles created that i can view....if any one can help me...Thanks

[vendechukp]

are u talking about the role

[jmodic]

SELECT * FROM dba_profiles;

[Fiza15]

Hi
Sorry ppl i should have made my qestion clear is how can i go in particular user's file to make changes so i can controll his activities...Thanks

[alapps]

As jmodic stated, the DBA_PROFILES view will list the avalable profiles to assign. The view DBA_USERS will list the profile name assigned to a user.

ALTER USER "username" PROFILE "profilename";


P.S. Management (users) is simple and easy (Point & Click) via the DBA STUDIO provided by Oracle vs. SQL.