Re: Detecting priviledges of role

Honestly, one shouldn't have to test for any privileges. Always write procedures as if the invoker has the privilege to do so, and if not, let the calling procedure trap the security error. If you want to be sure of completion without regard to the invoker's privileges, specify author's rights when compiling your procedure.

[Quoted] [Quoted] "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:9uavjq$1klv$1_at_as201.hinet.hr...
> How to programmatically (in Oracle Form - Developer6i) detect if one
> role has some priviledges? For example i'd like to be able to detect if
> role 'AAA' has priviledge 'SELECT' on table 'BBB' in shema 'CCC'.
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
>
Received on Sat Dec 01 2001 - 17:50:42 CET