Question
Can a table or synonym be invalidated?
Answers
A table or synonym can never be invalidated; only dependent objects are invalidated.


Suppose A Schema 2 Has Granted Necessary Privileges To The Schema 1 Through Roles. Is It Possible For A Program Unit In The Schema 1 To Refer The Database Objects In The
Schema 2 ?

No, a program unit in the schema 1 cannot reference the database objects in the schema 2, even if the schema 2 has granted necessary privileges to the schema 1 through roles. This is because granting privileges through roles does not work for program units. They can reference other schemp objects only if the necessary privilege has been granted directly to the schema.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What is a verification point?
  • Q The pleura recess includes(ABC) A. costodiaphragmatic recess B. costomediastinal recess C. phrennicomediastinal recess D. cupula of pleura E. recess between the fissure of lungs
  • Q Explain how you can set up Jenkins job?
  • Q For sales document: item data, which table is used?
  • Q Assume that a CPU has only two registers R1 and R2 and that only the following instruction is avaiable. XOR Ri , Rj ;{ Rj ! Ri Å Rj , for i, j=1,2} Using this XOR instruction , find an instruction sequence in order to exchange the contents of the Registers R1and R2.
  • Q Who is appointed as the Deputy National Security Advisor ?
  • Q Gandhara art blossom in whose reign?
  • Q Flies and humans can both get which condition
  • Q Have you create Properties and Methods for your own Controls?
  • Q What do you mean by zener breakdown and avalanche breakdown?
  • Q Explain the features available in btrieve commander?