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
- 8120 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
How does stored procedure reduce network traffic?
What is form and report?
What is difference between stored procedure and trigger?
What does pl sql stand for?
what is a cursor? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
How do I partition in sql?
What are its different types of dbms?
What is primary key and foreign key?
What is sap sql anywhere?
How do you pronounce sql?
What is auto increment in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
what are the 'mysql' command line arguments? : Sql dba
