Hi,
The following code work as you can see below, but if I put this
code in a package ( a procedure in a package) then I got
ORA-01031 insufficient privileges error.
This is absurd for me because it's the same user (an administrator)
that
owns the package, tablespace, table and everything.
From a
You need to read on up on permissions.
privileges that you get thru a role does not work for stored objects,
like proces/pkgs.
joe
Csillag Zsolt wrote:
> Hi,
>
> The following code work as you can see below, but if I put this
> code in a package ( a procedure in a package) then I got
> OR
Sorry, this is perfectly normal and makes sense when
you understand the security implications.
May I suggest the Concepts manual at tahiti.oracle.com?
Also, if you go take a look at www.orafaq.com you will find
an answer to this question, and being the lazy DBA that I
am, it will save me some t
Hi,
Thank you for your help. Now it works.
At 11:00 2001.12.16. -0800, you wrote:
>You need to read on up on permissions.
>
>privileges that you get thru a role does not work for stored objects, like
>proces/pkgs.
>
>joe
>
>
>
>
>Csillag Zsolt wrote:
>
>>Hi,
>>The following code work as you can