Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL issue

Options
  • 14-06-2011 8:10pm
    #1
    jjjade
    Registered Users Posts: 191 ✭✭


    Guys

    have sql server 2008 and practicing sql for an assignment. the login is window authentication.

    was asking to create a login called 'test' which i did. and asked to give it 'select' permissions to a table called customer, the code below wont word, can any 1 advise?

    GRANT SELECT, INSERT, UPDATE
    ON Customer
    TO 'test'

    thank you!!!


Comments

  • Options
    #2
    amen
    Registered Users Posts: 2,781 ✭✭✭amen


    SQL ON Line or google it


  • Options
    #3
    Malice
    Registered Users Posts: 15,065 ✭✭✭✭Malice


    jjjade wrote: »
    was asking to create a login called 'test' which i did. and asked to give it 'select' permissions to a table called customer, the code below wont word, can any 1 advise?
    For future reference it's a good idea to post whatever error messages you get and definitely do an internet search on the error message. Chances are someone else out there will have already come across your issue.


  • Options
    #4
    COYW
    Closed Accounts Posts: 2,930 ✭✭✭COYW


    All you need to have for the OP's request.

    Grant Permissions


Advertisement