How to see profile assigned to a user

Question

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it.

Now how can i see for TEST_USER which profile has been assigned?

I want some query that will check what profile a user is assigned with.

score 21 · Accepted Answer · edited Dec 27 '18 at 16:19

21

In order to find out the users and the profile assigned you can use the commands below.

DESC DBA_USERS;

This will show you all the fields name for which you want to query

SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS;

And this command will show you the user name, profile and account status i.e. which profile is assigned to which user

edited Dec 27 '18 at 16:19

James Douglas

answered Feb 11 '15 at 05:21

Sherzad Zahid

score 3 · Answer 2 · answered Oct 03 '13 at 07:07

3

answered Oct 03 '13 at 07:07

Nicolas Durand

2 Answers2