0

I have created one user in my oracle database. I have given read-only access to 2-3 schemas.

But I also want to grant access to those schemas with the ability to run packages and procedures.

How can I do that?

Granted read-only access to those schemas.

avocadoLambda
  • 1,332
  • 7
  • 16
  • 33
Megha Bhatia
  • 1
  • 1
  • 2
    I am not sure quite what you are asking for. Do you just want to `grant execute on <> to <>`? Or is that not what you want for some reason? – Justin Cave Dec 09 '22 at 16:05
  • Please check below [Related question](https://stackoverflow.com/questions/4305323/granting-rights-on-stored-procedure-to-another-user-of-oracle) – Assaduzzaman Sarker Dec 11 '22 at 14:03

1 Answers1

0
GRANT EXECUTE ON b.procedure_name TO a

Please check your query below

Granting Rights on Stored Procedure to another user of Oracle

Assaduzzaman Sarker
  • 1
  • 1