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...


how view used for security purposes?

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

How to assign sql query results to pl sql variables?

0 Answers  


How do I run a script in sql developer?

0 Answers  


What is mdf ldf and ndf?

0 Answers  


what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  


How many columns should be in an index?

0 Answers  


How can a pl sql block be executed?

0 Answers  


Do we need to create index on primary key?

0 Answers  


How can you tell the difference between an index and a view?

0 Answers  


What is offset in sql query?

0 Answers  


What is rownum in sql?

0 Answers  


how will i became good database developer?

1 Answers  


What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,


Categories