User Profile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: User Profile

  1. #1
    Join Date
    Jun 2002
    Posts
    65
    Hi all
    I am trying to find out where user profiles created that i can view....if any one can help me...Thanks

  2. #2
    Join Date
    Apr 2002
    Posts
    55
    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

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    SELECT * FROM dba_profiles;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2002
    Posts
    65
    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

  5. #5
    Join Date
    Jul 2002
    Location
    California
    Posts
    128


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width