Hi all
I am trying to find out where user profiles created that i can view....if any one can help me...Thanks
Printable View
Hi all
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
SELECT * FROM dba_profiles;
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
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.