1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how view used for security purposes?

Question Posted / nishi.swain@gmail.com

Answers were Sorted based on User's Feedback



how view used for security purposes?..

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

Is This Answer Correct ?    2 Yes 0 No

how view used for security purposes?..

Answer / madhusudhan.madireddy

limit access and view to required fields only

Is This Answer Correct ?    1 Yes 0 No

how view used for security purposes?..

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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are different types of refreshment techniques of materialised view

2 Answers  

How would you pass hints to the sql processor?

0 Answers  

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

what is a primary key? : Sql dba

0 Answers  




Temporary table vs Table variable in sql server?

0 Answers   Wipro,

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

What is primary key secondary key alternate key candidate key?

0 Answers  

What is structural independence and why is it important?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

What is left join in postgresql?

0 Answers  

Where do we use pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories