Geek Answers Handbook

Does Oracle create a privilege procedure?

If I have the privilege of creating a procedure and I do not have rights to update, and if I wrote instructions for updating in the procedure, will I update or report an error?

+4
source share
1 answer

By default, Oracle uses the qualifier rights model to determine the available privileges for the procedure. This means that by default the procedure will be executed with the privileges of the scheme in which it is defined.

So, if your schema does not have privileges to UPDATE the table used in the procedure, you will receive an error message.

+5
source

More articles:


All Articles