Results 1 to 3 of 3

Thread: Using View

  1. Dec 18th, 2002, 07:37 AM #1
    Luis Moises Rojas
    Luis Moises Rojas is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 1999
    Location
    Santo Domingo,D.N., Dom. Rep.
    Posts
    707

    Talking Using View

    I have a view on sql server and i want that the user only has access to this view, how can i do this?
    Reply With Quote Reply With Quote
  2. Dec 18th, 2002, 07:45 AM #2
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611

    Create new database

    I don't know for sure, but you could try to add a new database with only this view, and give the user only rights to this database. The view should get the data from the original database.
    Reply With Quote Reply With Quote
  3. Dec 18th, 2002, 08:42 AM #3
    Wokawidget
    Wokawidget is offline
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632

    Re: Using View

    Originally posted by Luis Moises Rojas
    I have a view on sql server and i want that the user only has access to this view, how can i do this?
    Eh? The User? All users, one user? Eh?

    Wokafish
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    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


Click Here to Expand Forum to Full Width