Re: Question about grants given to Roles
From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/08/05
Message-ID: <6jMi5.1365$c8.581869_at_typhoon-news1.southeast.rr.com>#1/1
Date: 2000/08/05
Message-ID: <6jMi5.1365$c8.581869_at_typhoon-news1.southeast.rr.com>#1/1
Zeeshan,
You need to query the view ROLE_TAB_PRIVS.
Regards,
Paul
"Zeeshan Basharat" <zbasharat_at_hotmail.com> wrote in message
news:398bf7e1_at_news.cyber.net.pk...
> Hello
> I have a problem here. I have created two roles in my office.
> First one is Accounts and other Sales.
> I gave select,insert and update grants on some tables to both the roles.
> Now I want to see on which table I gave grant to the role.
>
> OR
> I want to see the grants on the table given to the role.
>
> Please help me,
> Thanx in advance
> Zeeshan
>
>
>
Received on Sat Aug 05 2000 - 00:00:00 CEST