we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
Answer Posted / mathivanan
Of course it wont, it will error out..
As per the question, the user is creating a package inside which he is accessing a table that he has no access to.
it will error out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many columns can be used for creating index? : Sql dba
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what does the t-sql command ident_current does? : Transact sql
What is an invalid partition table?
What do you think about pl/sql?
Define sql delete statement.
What are two statement types in sql?
Describe types of sql statements?
What is over () in sql?
What does (*) mean in sql?
Why do we use %rowtype & %type in plsql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How many databases can sql express handle?