You must Sign In to post a response.
  • Category: SQL Server

    Explain what happens when a user accesses a database through a view.

    Explain what happens when a user accesses a database
    through a view.
  • #725519
    They will be able to see the data which is designed in the view. If user manipulate anything in the view, it will not affect the original data.
    Regards,
    Manick

  • #725533
    View is Temporary table you can say.It cannot be tempared as its is just a query which runs and get data .

    Instead of running select * from users.

    You can write a view select * from user and show that in grid. No Work from db then .

    Regards
    Rakesh Chaubey
    rakeshchaubey1989@gmail.com

  • #725534
    Hi.
    View is used when you dont want others to see the complete details of the database. I mean when we create view, we can restrict the users to see the inner complexity, relationships and some of the records from the table. So it provides more security in views and maintains the data integrity. It provides the simplified data to the user.

    Thanks

    Reena


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.