failed to update my dbase!

  • Thread starter Thread starter rcoco
  • Start date Start date
R

rcoco

I'm facing trouble to update the data in the SQLServer
2000. When ever I try to update it I get a message that goes like this:

SELECT permission denied on object 'staff', database 'dbname',
owner'owner name'.
UPDATE permission denied on object 'staff', database 'dbname', owner
'owner name'.
What Problem do you think this can be . I've tryed to look for the
restriction but there are non.
Thank you..
 
Well, the account you are running under does not have the necessary
permissions for the table you want to update and select from.

Use enterprise manager to set the security for the table and assign
the necessary permissions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top