var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: User Profile
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.
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:
-- as sys:
create view my_profile as
select u.name "USER_NAME", p.name "PROFILE"
sys.user$ u, sys.profname$ p
where u.resource$=p.profile# and u.name=user;
grant select on my_profile to public;