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

with this
select * from user_role_privs;
the result is the roles of the connect user???

On Fri, 21 May 2004 16:04:14 +0100, Jeremy <newspostings_at_hazelweb.co.uk> wrote:

>In article <9Forc.84305$325.1868012_at_news20.bellglobal.com>, G Dahler
>says...
>>
>> "G Dahler" <yellow-shark_at_spamex.com> a écrit dans le message de
>> news:2Borc.84244$325.1866734_at_news20.bellglobal.com...
>> >
>> > "juan" <aaaaa_at_aaa.com> a écrit dans le message de
>> > news:be0sa0tpp32evanncp1jt55b1cqeadht75_at_4ax.com...
>> > > i am spanish and my english is very bad, please the answres not
>> > > difficult, thank you.
>> > >
>> > > i want to consult the role assigned to one user, in what table or view
>> > > have i to consult.
>> > > i make the role, isn=3Ft a system role.
>> > > thank you.
>> >
>> > Select *
>> > from dba_role_privs
>> > where grantee='YOUR_USER_HERE'
>> > /
>> >
>>
>> I forgot to say that DBA_ROLE_PRIVS is not accessible to any user. Connect
>> as SYS or DBA
>>
>>
>>
>
>How about :
>
>select *
>from user_role_privs;
>
>?
Received on Fri May 21 2004 - 10:44:06 CDT