Results 1 to 2 of 2

Thread: User Profile

  1. #1
    Join Date
    Sep 2004
    Posts
    60

    Question Unanswered: User Profile

    Hi Experts.

    I have assinged a profile to a user(normal database user).

    Is ther any way that user can see profile assinged to him. Please take into consideration that user is not having asscess to dba tables & views.
    He is a normal database user without sys privilages.

    I checked user_users, but it have no column for profile.

    Thanks

  2. #2
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    I don't see any view or function that would show profile other than the DBA views.

    You could create your own SYS views off the base tables, might be considered a poor practice, but it would do what you want:

    Code:
    -- as sys:
    create view my_profile as
    select u.name "USER_NAME", p.name "PROFILE"
    from
    sys.user$ u, sys.profname$ p
    where u.resource$=p.profile# and u.name=user;
    
    grant select on my_profile to public;

Posting Permissions

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