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
What is difference between rank () row_number () and dense_rank () in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How does a covering index work?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Which is better trigger or stored procedure?
How do I truncate a sql log file?
What are the two virtual tables available at the time of database trigger execution?
How many functions are there in sql?
How to run pl/sql statements in sql*plus?
Is json a nosql?
How many sql commands are there?
What is auto increment?
How many joins in sql?
what are the authentication modes in sql server? : Sql dba
Explain what is a subquery ?