SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard
    Join Date
    Apr 2004
    Location
    dublin
    Posts
    2,036
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server Permissions

    Hi all,

    How do I make SQL Server db table permissions take effect?

    I just gave select permissions to a table but still not working.

    Thanks.

    Kevin.

  2. #2
    SitePoint Guru
    Join Date
    Aug 2003
    Location
    CT
    Posts
    643
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is it for the right user in your connection string, or login?

  3. #3
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    two ways

    1. either use QA and use the grant permission functions
    or
    2. in EM right click the table and choose properties and assign the select permissions to it

    But one thing you have to watch out for is are you granting permissions to the right users ???


Bookmarks

Posting Permissions

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