how view used for security purposes?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the life of an sql statement?

521


What are types of exception?

532


What is the difference among union, minus and intersect?

544


What kind of join is join?

555


What is sql stand for?

571






Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

524


Why plvtab is considered as the easiest way to access the pl/sql table?

617


What are the sql aggregate functions?

602


Can we use ddl statements in stored procedure?

696


Define select, insert, create, delete, update, drop keywords

596


What is varchar sql?

615


What is a join query?

546


what are the different functions in sorting an array? : Sql dba

579


what is the syntax for using sql_variant_property? : Transact sql

529


Is truncate ddl or dml?

541