Prior to Oracle 12c, when a PL/SQL program accessed a table, you needed to grant access to the user to both the PL/SQL program and the table that it accessed.
If you didn’t, you would get some kind of access error.
Now, in Oracle 12c, you can grant access to the user to just the PL/SQL program, and not the table it reads from.
This makes it much more secure. It means that you can set up your database so users do not have access to the underlying tables.
No comments:
Post a Comment