Post reply

Permission Table for many users

  • November 23, 2009 at 4:19 am

    #212802

    Hi,

    Many Thanks for your help in advance, I have want I think is a really easy question but I havent had much practice with this side of things.

    I have an abstracts table, each abstract is associated with a region. We have users who should only be given access to a region or regions.

    How can I set this up with permission such that a user has access to North America and Europe can only see these associated records in the abstract table that contains all the regions.

    I am thinking along the lines of a view for each region and then unioning the views together, whichever regions a user has permissions for the view would return the accessible results.

    Many Thanks, you guys always help me out.

    Oliver

  • November 25, 2009 at 9:03 am

    #1084128

    create views to access the data for each user

  • November 27, 2009 at 9:44 am

    #1084967

    Use views to restrict the scope and Stored procedures to add data.

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • November 27, 2009 at 10:22 am

    #1084979

    Many Thanks,

    I have also discovered that UDF's might be a way forward, by passing the username of the user loggining in and finding out what group member that user has rights it i will try to create a temp table, and then create a udf that pulls back all the abstracts applicable to that user.

    Cheers have a good weekend.

    Oliver

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply