count number of grants in a role

[raknunna]

Hi,

Please provide a query to find "count(*num ber) of grants in a role. we have a role ALPHA_ROLE and I just want count of only select grants existing in the role. Can someone help.

Thanks in advance.

Rakesh N.

[Rabbit]

We would need more information about the tables, fields, and relationships involved. Right now, there's not much to work with.

[premkumar sp]

Try this
Select count(*) from dba_tab_privs where privilege='SELE CT' and grantee='<rolen ame>'