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 the clause we need to add in function body to return variable?

0 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

Define commit?

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

What is memory optimized table?

0 Answers  

---

what are the advantages of sql ? : Sql dba

0 Answers  

---

What is the difference between the conventional and direct path loader? : aql loader

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

how to create a database in oracle?

3 Answers  

---

how to use 'mysql' to run sql statements? : Sql dba

0 Answers  

---