Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

define join and explain different type of joins? : Sql dba

0 Answers  

what are the advantages of cursors than procedures?

2 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

What is raid? How does it help storage of databases?

0 Answers  

How many types of normalization are there?

0 Answers  

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

What are all the common sql functions?

0 Answers  

What are the two parts of design view?

0 Answers  

is mysql query is case sensitive? : Sql dba

0 Answers  

What is file based approach?

0 Answers  

How many triggers can be applied to a table?

0 Answers  

What are the types of sql commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories