Answer / ashokram s

Using view you can restrict the data and thus granting privilege on the view instead of base table can ensure security that all data cant be accessible by a particular user

Answer / madhusudhan.madireddy

limit access and view to required fields only

Answer / santosh kumar

Hi,

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object, so it occupies space.

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

what is constraining table?

2 Answers  

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

What are procedures used for?

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

How many types of keys are there in sql?

0 Answers  

---

What is nosql vs sql?

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---