Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: permission denied on object

    I connect in my database "test" with the user "teste" by SQL QueryAnalyzer (localhost;DatabaseName=test;SelectMethod=cursor),
    but when i run the SQL (select * from user) return the error
    "SELECT permission denied on object 'user', database 'test', owner 'teste'.


    I already put all permission to the user "user".

    My database test has a table "user". The owner´s "teste" and the Type´s "User"
    The user "teste" has all permission to the table "user" (select, update, insert ...)

    what i need to do ? What´s wrong ?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The user may possibly be denied access to the table or a member of a group that is denied access to the table or possibly a member of db_denydatareader.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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