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 do I tune a sql query?
What is linq to sql?
what are all the common sql function? : Sql dba
What is pl sql record in oracle?
State some properties of relational databases?
What do you understand by exception handling in pl/sql?
What is data type in database?
What is a table in a database?
What information is needed to connect sql*plus an oracle server?
Write a sql select query that only returns each name only once from a table?
Explain lock escalation? : Transact sql
Is sql a programming?
What is difference between sql and mysql?
What is the difference between execution of triggers and stored procedures?
How long it takes to learn pl sql?