Re: i want to consult the role assigned to one user

"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 - 11:00:37 CDT