1

Topic: To grant the right to packet change

I created procedure, but it is necessary that another (user1) could change it (to add procedures in a packet .)
As it to make

GRANT ALTER ON "PKG????" TO "user1";

Does not work

2

Re: To grant the right to packet change

abort;
So always happens, when you "invent" the reality, instead of you live by rules of the existing...
You where such privilege on a packet saw?

3

Re: To grant the right to packet change

Transfer of a packet to other circuit (user1) not to offer
Really it is impossible without transfer

4

Re: To grant the right to packet change

abort;
esteem . Can on thought pushes...

5

Re: To grant the right to packet change

abort wrote:

really it is impossible without transfer

It is possible and without transfer: "create any procedure"

6

Re: To grant the right to packet change

7

Re: To grant the right to packet change

To grant the rights to executions to the given procedure to other user

8

Re: To grant the right to packet change

http://sd-company.su/article/sql/grant_oracle

9

Re: To grant the right to packet change

SAS2014 wrote:

to grant the rights to executions to the given procedure to other user

the Objective privilege does not give the rights to editing.

10

Re: To grant the right to packet change

AmKad wrote:

it is passed...
The objective privilege does not give the rights to editing.

Clearly... Interesting author  the decision