Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: i want to consult the role assigned to one user
ok thank you
On Fri, 21 May 2004 12:00:37 -0400, "G Dahler" <yellow-shark_at_spamex.com> wrote:
>
>"juan" <aaaaa_at_aaa.com> a écrit dans le message de
>news:js8sa011etpiqpjpkb0bjgmu09rv6hn3ge_at_4ax.com...
>> with this
>> select * from user_role_privs;
>> the result is the roles of the connect user???
>
>Nope. You'll get a list of all the roles for all users. You need to add a
>where clause to restrict the selction to
>the specific user your interested in:
>
>select *
>from user_role_privs
>where username='JUAN';
>
>for example
>
Received on Fri May 21 2004 - 12:54:08 CDT