Interested to Buy Any Domain ? << Click Here >> for more details...
how view used for security purposes?
- 3 Answers
- 5801 Views
- Glam India, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / madhusudhan.madireddy
limit access and view to required fields only
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
How to assign sql query results to pl sql variables?
How do I run a script in sql developer?
What is mdf ldf and ndf?
what are the advantages and disadvantages of views in a database? : Sql dba
How many columns should be in an index?
How can a pl sql block be executed?
Do we need to create index on primary key?
How can you tell the difference between an index and a view?
What is offset in sql query?
What is rownum in sql?
how will i became good database developer?
What is Difference Between Unique and Primary Key Constraints?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
