CODEWITHSUNDEEP
oracle-databaseprivileges
mangesh5171
mangesh5171

Reputation: 49

How I can GRANT EXECUTE ON <only 1 procedure OR function in package> TO USER

I need to allow user to execute only one function inside a package. How I can

GRANT EXECUTE ON <only 1 procedure OR function in package> TO USER

Upvotes: 1

Views: 2177

Answers (2)

qwerty qwerty
qwerty qwerty

Reputation: 36

You can probably create 2 packages:

  • main package - contents all logic
  • interface package - contents wrapper methods. "wrapper methods" - just make calls real methods from main package you want to get access by grant.

And get grants to interface package.

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142968

You can't. Grant affects the whole package.

Upvotes: 3

Related Questions