I am trying to find out where user profiles created that i can view....if any one can help me...Thanks
are u talking about the role
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
SELECT * FROM dba_profiles;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
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.