how view used for security purposes?
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 |
What is mutating table error?
What is auto increment feature in sql?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
How to assign sql query results to pl sql variables?
What is a rank in sql?
What is pl sql script?
Why we use stored procedure instead of query?
How can we find duplicate records in a table?
What is oracle pl sql developer?
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
How do you update a table in sql?
how do you tune the slow running queries in oracle db , explain the methodology
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)