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 are the usage of SAVEPOINTS?
List the different type of joins?
Explain the difference between sql and mysql.
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is the difference among union, minus and intersect?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is sql select statement?
What is cursor in pl sql?
What is a package ? What are the advantages of packages ?
how can i read write files from pl/sql
how can stop the sequence with mention the max value and with out mention the max value
how can we know the count/number of elements of an array? : Sql dba