Execution permission procedure

[rafdutra]

Good afternoon everyone.

I have a question regarding Oracle's permissions. I have a package that should only be used by my Owner CLT. I then executed:



However, within this package there are procedures that call procedures of other packages, and that's where the mistake that tells me that I do not I have privileges to access the last package.

The Grant runs above Should not it possible to run my package and any other call for it ??



Thanks!

[victorhugomuniz]

I believe that when giving grant to a particular object this does not interfere with dependent or that are used ...
being necessary to give grant on all other objects

[BORGES_RS]

It is worth remembering that it is interesting for you to understand the functioning, just do the same grant with some super user, since your user does not have this permission.
We have the idea that even giving privileges, when they change other data, tables or the like, it requires privileges a little more than execute.

Test with a DBA user, just for you to understand what I say, after testing and seeing it worked, do through Begin Tran and Rolback Tran.

To avoid, or if you are using SQL Developer, just give a ROLBACK.