Re: FGA a role ?

"Stefan" <stefan_at_dragolov.com> a écrit dans le message de news:1111985710.336201.231090_at_o13g2000cwo.googlegroups.com...
| Is it possible to have an FGA policy for a role.
|
| For example, I know that a policy can exclude a user as such
| "user not in ('user1', 'user1')"
|
| Is it possible to do this:
|
| "role not in ('role1', 'role2')"
|
| Thanks,
| Stefan
|

Maybe:

not exists (select 1 from session_roles where role in ('role1','role2'))

Regards
Michel Cadot Received on Sun Mar 27 2005 - 23:40:02 CST