Creating views with replace option, Database Management System

Creating views with Replace option: This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted on it.

 

 

Posted Date: 3/11/2013 1:26:31 AM | Location : United States







Related Discussions:- Creating views with replace option, Assignment Help, Ask Question on Creating views with replace option, Get Answer, Expert's Help, Creating views with replace option Discussions

Write discussion on Creating views with replace option
Your posts are moderated
Related Questions

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

Why is need for the multiple access paths?

what is the need of a log in dbms

What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

explain exhausitively the problems associated with er diagrams with ellustrations

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac