Results 1 to 2 of 2

Thread: Creating A View

  1. 12-05-2005, 05:44 PM #1
    Teach
    Teach is offline Registered User
    Join Date
    Dec 2005
    Posts
    3

    Creating A View

    What are some possible purposes of creating a view and how can it be used to reinforce data security. What description of circumstances can be used for a view to save re-programming?
    Reply With Quote Reply With Quote
  2. 12-06-2005, 10:57 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If you constantly query table for same set of data, you can create a view for that. From security point of view, you grant permission on view instead of table so user can only access certain rows in the table via view.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules