sql - Oracle create procedure privilege? -


If I have a procedure privilege and I do not have the updated privileges and if I wrote an updated statement in the process Will update or give me an error?

By default, uses a fixed authority model to detect the available rights for Oracle Process is going on, this means that by default the process is executed with the privileges of the schema in which it is defined.

So if your schema does not have the privilege of updating the table used in the process, you will get an error.


Comments

Popular posts from this blog

apache - 504 Gateway Time-out The server didn't respond in time. How to fix it? -

c# - .net WebSocket: CloseOutputAsync vs CloseAsync -

c++ - How to properly scale qgroupbox title with stylesheet for high resolution display? -