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

Is t sql a programming language?

753


What is dml and ddl?

711


What is the difference between a database and a relational database?

762


how can we destroy the session, how can we unset the variable of a session? : Sql dba

727


What is difference between procedure and trigger?

669






Explain dml and ddl?

737


What is data abstraction in sql?

717


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

754


Is sql procedural language?

733


How many commands are in sql?

715


What is crud diagram?

676


What is %rowtype in pl sql?

680


What is cursor explain with example?

732


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1730


What is implicit cursor in pl sql?

738