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.

what is meant by nl2br()? : Sql dba

0 Answers  

---

What are database links used for?

0 Answers  

---

What is data manipulation language?

0 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

How is sql used in oracle?

0 Answers  

---

what is sql profiler? : Sql dba

0 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

How do you remove duplicates without using distinct in sql?

0 Answers  

---

what is the boundary line in varrays?

1 Answers   HCL,

---

What are the sql versions?

0 Answers  

---