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


Please Help Members By Posting Answers For Below Questions

what is a trigger? : Sql dba

654


What is union and union all keyword in sql?

648


Which one is faster ienumerable or iqueryable?

569


Does inner join remove duplicates?

621


What is pl sql commands?

648






How do I find duplicates in two columns?

656


Mention what is the use of function "module procedure" in pl/sql?

689


Which kind of parameters cannot have a default value in pl sql?

684


How to return multiple rows from the stored procedure?

621


Why is stored procedure faster than query?

581


how can we destroy the cookie? : Sql dba

643


How do I view output in sql developer?

687


what is innodb? : Sql dba

672


What is a delimiter in sas?

639


What is the difference between row level and statement level trigger?

621