SQL Server Performance

Access

Discussion in 'General DBA Questions' started by sunda, Jul 2, 2007.

  1. sunda New Member

    Hello!

    I am having a problem of grant access to an user i´ve just created. I have a huge db and want this user get access to only one table. how could i do this?

    Thanks since now for any help.

  2. satya Moderator

    What sort of permissions, READ or WRITE?
    Use TSQL from query analyzer using:

    GRANT INSERT, UPDATE, DELETE ON <tablename> TO <newusername>

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    or ,
    if you have Enterpise manager, right click the table and select permission and grant nesseary permissions

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. sunda New Member

    Thanks, but i am having more problem to deny access to other tables. I did as u told above, but the same user is able to query other tables. do i have to deny access table to table?

    Thanks again.
  5. satya Moderator

    If this user is present in fixed database role, db_datareader then deny that role. IN this case better to manage using database roles for such access.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  6. sunda New Member

    That is all! Thanks a lot again! Bye for now!

Share This Page