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?
- 3 Answers
- 7603 Views
- TCS, I also Faced
- E-Mail Answers
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 partition in sql query?
What is delimiter in pl sql?
What is the difference between a primary key and a clustered index?
How do I debug a stored procedure?
Is it possible to pass parameters to triggers?
what is oltp (online transaction processing)? : Sql dba
What is a stored procedure in sql with example?
What is an emotional trigger?
What is the largest value that can be stored in a byte data field?
What is the cause of mutating table error and how can we solve it?
How to use sql statements in pl/sql?
What is number function in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What are secondary keys?
What is scope and visibility in PL/SQL?
